How to set the backup retention duration (Enterprise Manager)
From How to Install SQL Server 2000
How To
How to set the backup retention duration (Enterprise Manager)
To set the backup retention duration
- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Database Settings tab.
- In the Default backup media retention (days) box, type or select a value from 0 through 365 to set the number of days the backup medium will be retained after a database or transaction log backup.
The default value is 0 days.