this would be the option to set how many backups I want to keep. I set it
to "After 1 day", yet I have 4 days worth of backups in my backup directory.
Did I set the wrong option? I only want 1 backup.
Thanks, Andre
Andre,
Well... the others have expired, but they have not been deleted. Both SQL
Server 2000 and SQL Server 2005 Maintenance Plans have a function to delete
backup files older than some period, so you should check that out for
whatever version you are running.
RLF
"Andre" <nospam@.spam.com> wrote in message
news:%23PAzvvnuHHA.3480@.TK2MSFTNGP04.phx.gbl...
> Can someone explain the option "backup set will expire" to me? I figured
> this would be the option to set how many backups I want to keep. I set it
> to "After 1 day", yet I have 4 days worth of backups in my backup
> directory. Did I set the wrong option? I only want 1 backup.
> Thanks, Andre
>
|||This was very apparent in SQL2k, but I can't find it in SQL2k5. Where is
it?
|||Andre,
On the Maintenance Plan task designer (kind of like DTS / SSIS) drag the
Maintenance Cleanup Task and set it up to match your path, retention, etc.
RLF
"Andre" <nospam@.spam.com> wrote in message
news:u9DgHJpuHHA.3476@.TK2MSFTNGP02.phx.gbl...
> This was very apparent in SQL2k, but I can't find it in SQL2k5. Where is
> it?
>
|||The option you want to use has been pointed out to you by Russell. I just want to mention what the
option you mention is for:
EXPIREDATE will only prohibiting doing an INIT to overwrite the backup before the specified date. It
will not assist in keeping x number of old backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andre" <nospam@.spam.com> wrote in message news:%23PAzvvnuHHA.3480@.TK2MSFTNGP04.phx.gbl...
> Can someone explain the option "backup set will expire" to me? I figured this would be the option
> to set how many backups I want to keep. I set it to "After 1 day", yet I have 4 days worth of
> backups in my backup directory. Did I set the wrong option? I only want 1 backup.
> Thanks, Andre
>
|||Thank you both. I will like SQL2005 one of these days...right?
Stillfumbling my way around, obviously.
