After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.
SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts
I used generate scripts for a historical SQL Server 2017-to-2005 migration. It was a logical migration rather than a backward backup restore.
Where is the Default Settings for Backup Compression? – Interview Question of the Week #191
Where are the default settings for backup compression? The Back Up dialog shows three options. Here is where the server default lives and how to set it.
Estimated Completion Time for Backup, Restore and DBCC
The estimated completion time of a backup, restore or DBCC command is one query away. This post builds a monitor query on sys.dm_exec_requests and watches a backup, a restore and a DBCC check in a second window. It also covers STATS and the DBCC step name.
SQL SERVER – Rebuild Index Job Failed – Error: 9002 – The Transaction Log for Database ‘PinalDB’ is Full Due to ‘LOG_BACKUP’
A rebuild index job kept failing with error 9002: The transaction log for database ‘PinalDB’ is full due to ‘LOG_BACKUP’. Here is how I found the real cause.
Rename Logical File Name of a SQL Server Database
To rename logical file name entries in SQL Server, use ALTER DATABASE with MODIFY FILE and NEWNAME. This post builds a demo database, renames both files and checks the result. It also covers names with dots and the two errors that stop a rename.
SQL SERVER – FIX: Backup to URL Error: Operating System Error 50(The Request is Not Supported.)
My Backup to URL jobs started failing with Operating system error 50 (The request is not supported.). Here are the ERRORLOG messages and how I fixed it.