Re: Overwriting backups

From: Leon Shargorodsky (Shargorodsky_at_discussions.microsoft.com)
Date: 01/09/05 

Date: Sat, 8 Jan 2005 18:35:02 -0800

Thank you, Andrew, I hope this is something that is going to be addressed in
Yukon.
Thanks again for your help!

"Andrew J. Kelly" wrote:

> You can't if you are using a single device. It is all or nothing with your
> only options being to use INIT or NOINIT. INIT will remove ALL files in the
> device and NOINIT will simply append. Don't use a logical device and
> instead backup to a different file name each time. Then you can delete what
> you want.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Leon Shargorodsky" <Leon Shargorodsky@discussions.microsoft.com> wrote in
> message news:FA6D9E38-FD99-456D-93B0-7C3ED322E3E1@microsoft.com...
> > I'm backing up my transaction log on backup device every 15 minutes. I
> > want
> > every backup expire in 1 hour so only 4 sequential transaction log backups
> > reside on my backup device. How do I do that? Thank you in advance
> >
> > Leon
> >
>
>
>