Configuration (Level 4)
Administration scripts may have used these configuration options. For more information about configuration options, see sp_configure and Setting Configuration Options.
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| Administration scripts may have used the nonadvanced media retention option to set the number of days to retain each backup medium after it is used for a database or transaction log dump. | media retention is now an advanced option.
Expect different results as compared to earlier versions of Microsoft® SQL Server™. Expect the media retention configuration option to appear only if you have enabled the advanced configuration options of sp_configure. |