Is there any command for delete a dbs backup set?

Thanks!

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

Try this...

Hope this will help u.

Does that mean the only way to delete the backup set is to turf the entire thing?

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

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.

__________________
cheers
Aman

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.

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!