HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to delete a Backup from a backup set in SQL Server 2008 R2

Submitted by: @import:stackexchange-dba··
0
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.