Delete existing backups

30 Jun 2005 2:16 PM

Star

Hi all,

I have the file MYBACKUPS.BAK
that contains several backups

001-Back1 (Complete)
002-Back2 (Complete)
003-Back3 (Complete)

(They are always Complete)

How can I delete from Query Analyzer '002-Back2'?
I haven't been able to find how to do that...

Thanks!

30 Jun 2005 2:51 PM

Narayana Vyas Kondreddi

I don't think you can delete individual backups from a backup file.

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

"Star" <noem***@noemail.com> wrote in message
news:eiLLF5XfFHA.3916@tk2msftngp13.phx.gbl...
Hi all,

I have the file MYBACKUPS.BAK
that contains several backups

001-Back1 (Complete)
002-Back2 (Complete)
003-Back3 (Complete)

(They are always Complete)

How can I delete from Query Analyzer '002-Back2'?
I haven't been able to find how to do that...

Thanks!

30 Jun 2005 8:44 PM

Hari Prasad

Hi,

You cant delete a backup file from a appended backup file. I recommend you
to take seperate backup files by specifying WITH INIT option.
When you generate the backup file prefix timestamp along with the name. Best
method is use Maintenance plan.

Thanks
Hari
SQL Server MVP

Show quote

"Star" <noem***@noemail.com> wrote in message
news:eiLLF5XfFHA.3916@tk2msftngp13.phx.gbl...
> Hi all,
>
> I have the file MYBACKUPS.BAK
> that contains several backups
>
> 001-Back1 (Complete)
> 002-Back2 (Complete)
> 003-Back3 (Complete)
>
> (They are always Complete)
>
> How can I delete from Query Analyzer '002-Back2'?
> I haven't been able to find how to do that...
>
>
> Thanks!