snippetMinor
How to delete a Backup from a backup set in SQL Server 2008 R2
Viewed 0 times
2008deletesqlhowserverfromsetbackup
Problem
The title pretty much sums it up. We are running out of space on our backup disks, and need to remove old backups out of the set. I can't seem to find any information on this.
Solution
I would change your backup strategy to write to individual files for each database backup. You could then have a maintenance plan step that examines your backup location and removes *.bak files older the X days.
Context
StackExchange Database Administrators Q#7468, answer score: 9
Revisions (0)
No revisions yet.