SQL SERVER – DPM Backup Failure – E_COORD_LOG_CHAIN_BROKEN – The Backup Failed Because of a Gap in The LSN the Log Files
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.
Transaction Log Backups Based on Log Size
Transaction log backups on a schedule can miss a burst of activity that fills the disk. This post builds a procedure that reads the log written since the last backup and takes a log backup once it passes a limit you choose. It also explains why the old habit of shrinking the log after each backup does harm.
Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured
Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.
SQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed
One database would not seed to the secondary replica. Here is how sys.dm_hadr_physical_seeding_stats showed failure_code 15 and VDI Client Failed.
Delete Old Backup Files in SQL Express with PowerShell
SQL Server Express has no SQL Server Agent, so nothing runs to delete old backup files and the disk slowly fills. This post gives a PowerShell script that removes backup files older than a set number of days, tests it with a dry run, refuses to delete when any backup type has no recent file, and shows how to schedule it with Task Scheduler.
SQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State
A client used AlwaysOn automatic seeding for a huge database, but it stayed in Restoring state on the secondary. Here is the reason we found.