September 23, 2007 at 1:56 pm
Is there a command to delete a dbs backup set? I have run a command a few times and have a few backup sets which I would like to turf.
Thanks.
September 24, 2007 at 1:06 am
Does this work?
EXEC master.dbo.sp_dropdevice @logicalname = N'somename'
Good luck!:)
September 24, 2007 at 7:21 am
Does that mean the only way to delete the backup set is to turf the entire thing?
September 24, 2007 at 8:50 am
Martin Brice (9/24/2007)
Does that mean the only way to delete the backup set is to turf the entire thing?
AFAIK this is the case, i.e. you would need to delete the whole backup file. The backup files use MTF (Microsoft Tape Format), these are sequential. It does not have a table of contents or anything similar, so one would need to scan through the whole file to identify the backup sets. The good thing about this is that the individual backup sets are not referenced, and the backup is just a concatenation of these backup sets. So in theory it is possible to remove an individual backup set, I have not seen such a tool, but it would not take long to write one.
The MTF format uses four character block identifiers, so in theory, once you identify the backup set you can remove it by editing the backup file (do make a copy!). Look for the word "SSET", these four characters identify the beginning of the individual backup sets.
Regards,
Andras
September 24, 2007 at 12:03 pm
Maybe I'm the one that's not doing something properly (most likely the case :>). I am trying to setup an automated backup process. Can you suggest any links on best practises (not a book length please? :>?) of how to setup and run backups?
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply