|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Transaction Log Backups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transaction Log Backups
|
|
| Joe Sullivan 2002-11-11, 5:23 pm |
| I have a quick, and hopefully easy, question...
If I am appending transaction backups to a file device
(ie db.TRN), how do I get rid of old backups within the
file device (ie., I don't need all of the transaction
backups from 2 weeks ago, as they are stored to tape)?
Thanks,
Joe
| |
| Mike John 2002-11-11, 5:23 pm |
| Shorat - easy answer - You don't (can't) ,Multiple backups to one file
append to the file until uou do a backup to same file WITH INIT clause
specified. WITH INIT overwrites the lot. Personal preference is 1 backup in
one file, file name generated to include date/time etc.
Mike John
"Joe Sullivan" <iwork@theagency.com> wrote in message
news:478601c289d3$ea1e3c30$3ae
f2ecf@TKMSFTNGXA09...
> I have a quick, and hopefully easy, question...
> If I am appending transaction backups to a file device
> (ie db.TRN), how do I get rid of old backups within the
> file device (ie., I don't need all of the transaction
> backups from 2 weeks ago, as they are stored to tape)?
>
> Thanks,
> Joe
|
|
|
|
|