Too many DBAs I meet have no recent backup. Here is a script that shows when each database had its last Full Backup and how big that backup was.
SQL SERVER – DPM Backup Failure – E_COORD_LOG_CHAIN_BROKEN – The Backup Failed Because of a Gap in The LSN the Log Files
SQL SERVER – DPM Backup Failure – E_COORD_LOG_CHAIN_BROKEN – The Backup Failed Because of a Gap in The LSN the Log Files
SQL SERVER – Error: Could not Load File or Assembly Microsoft. SqlServer. management. sdk. sfc Version 12.0.0.0
Could not load file or assembly errors come in many flavors. Here is how to read the assembly name and version in the message and fix the missing file.
DBCC CHECKDB Running Slow? Check the MAXDOP Option
DBCC CHECKDB running slow can trace back to the MAXDOP option. A CHECKDB with no MAXDOP option uses the server’s max degree of parallelism, and one with its own option overrides it. This post times CHECKDB on a 2 GB database with four settings, adds PHYSICAL_ONLY, and lists the other causes to rule out.
Azure – Which One to Get – Standard Disks or Premium Disks
Many customers get a slower SQL Server after moving to Azure. Should you pick Standard or Premium Disks? My short answer is Premium, and here is why.
SQL SERVER – How to Find Free Log Space in SQL Server?
Free Log Space is reusable capacity inside an allocated transaction log. I measure disk space and file size separately.
Restore Database Wizard Slow to Open in SSMS
The Restore Database Wizard reads the backup history stored in msdb before it opens. When that history has grown for years, the wizard is slow. This post counts the history, deletes it in monthly steps with sp_delete_backuphistory, shows how to clean one database’s history, and sets up a regular cleanup so the wizard stays fast.