Purpose

The purpose of this article is to teach you the process of setting up the backup retention duration in Microsoft SQL Server 2000.

To Set the Backup Retention Duration

Media retention option is used to provide a system-wide default for the length of time to retain each backup set. The media retention option helps protect backups from being overwritten until the specified number of days has elapsed. When you set media retention, you do not have to specify the length of time to retain system backups each time you perform a backup. The default is 0 days.

Following steps describe you the step by step details of setting up  backup retention duration:

1. Click Start, then go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

 2. Right click the registered SQL Server i.e. PC54, then click Properties, now click the Database Setting tab.

3. Now, set or type a value for Default backup media retention (days), the default is 0.

4. Click OK, then click Yes.