Hi,
Is it possible to remove or expire backup sets from a backup device
which don't currently have an expiry?
We have some backup devices which contain lots of transaction logs
which need removing. We now specify RETAIN_DAYS as part of the backup
command.
Need to do this in both SQL2K & SQL 2005 (Standard)
Thanks
DaveRETAIN_DAYS and EXPIREDATE has nothing to do with automatic removing of old
backups. In fact, you
cannot even remove old backups from a backup device while keeping newer ones
(INIT is all or
nothing). Consider writing scripts or using maint plans so you have several
backup files and the
oldest ones are re-used with INIT or deleted.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:treos25nhk0gcgrm851bo3rejdvjl8542u@.
4ax.com...
> Hi,
> Is it possible to remove or expire backup sets from a backup device
> which don't currently have an expiry?
> We have some backup devices which contain lots of transaction logs
> which need removing. We now specify RETAIN_DAYS as part of the backup
> command.
> Need to do this in both SQL2K & SQL 2005 (Standard)
> Thanks
> Dave|||Hi,
I read somewhere that media retention could be used to control this
but could not find out how to set it.
I guess you are saying take the backup device (file) top take then run
a single backup with INIT to clear out the entires.?
Dave
On Fri, 9 Feb 2007 10:43:13 +0100, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>RETAIN_DAYS and EXPIREDATE has nothing to do with automatic removing of old
backups. In fact, you
>cannot even remove old backups from a backup device while keeping newer one
s (INIT is all or
>nothing). Consider writing scripts or using maint plans so you have several
backup files and the
>oldest ones are re-used with INIT or deleted.|||> I guess you are saying take the backup device (file) top take then run
> a single backup with INIT to clear out the entires.?
I'm sorry, but I didn't get that... Can you re-phrase?
Say you have a backup device with, say, 10 backups on it. You can not remove
only 5 of those. You
can overwrite the lot using INIT, or append using NOINIT (default). RETAINDA
YS etc does not affect
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:n3mos2t0ip5enqpr2h8tibk43ktq79d9rt@.
4ax.com...[vbcol=seagreen]
> Hi,
> I read somewhere that media retention could be used to control this
> but could not find out how to set it.
> I guess you are saying take the backup device (file) top take then run
> a single backup with INIT to clear out the entires.?
> Dave
>
> On Fri, 9 Feb 2007 10:43:13 +0100, "Tibor Karaszi"
> <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>|||>> I guess you are saying take the backup device (file) top take then run
>I'm sorry, but I didn't get that... Can you re-phrase?
>
Yes it was complete jibberish wasnt it :-)
I meant to say move the backup device (file) onto tape then run a
backup INIT to clear the old entires.
>Say you have a backup device with, say, 10 backups on it. You can not remov
e only 5 of those. You
>can overwrite the lot using INIT, or append using NOINIT (default). RETAIND
AYS etc does not affect
>this.
Ok I understand.
Thanks for your help
Dave
No comments:
Post a Comment