Thursday, March 22, 2012

Backup retention period Setting

In sql2005 the database backup retention has been added in sql server properties in database setting.

In 2000 we had a comfortable option to set retention based on maintenance plan,files and also our space availabilty.It has helped the dba's a lot.But it has been removed in sql 2005.

Is that sql server setting is the only retention period setting or do we have to set in anyother tabs..

Thanks

There are two places where backup retention is specified:

First, as you discovered, there is an instance-wide default setting for backup media retention.

Secondly, that value can be overridden for any backup operation by using the "BACKUP DATABASE WITH EXPIREDATE = " option. or the WITH RETAINDAYS option.

Thus, you can specify for each backup, and each backup job, what the retention should be.

No comments:

Post a Comment