527
Chapter 19: Confi guring SQL Server
19
Using T-SQL-code, you can use the following command to set the PAGE_VERIFY option for
the AdventureWorks2012 sample database to TORN_PAGE_DETECTION:ALTER DATABASE AdventureWorks2012 SET PAGE_VERIFY TORN_PAGE_DETECTION;To view the page verifi cation level of a database, query the page_verify_option_desc column in the sys
.databasescatalog view.Media Retention
The media retention option sets the number of days to retain each backup set. The
default value for media retention is 0 days. This option helps protect backups from
being overwritten until the specifi ed number of days has elapsed.In Management Studio, you can set the media retention server confi guration option
by entering the number of days to retain each backup media in the Default Backup Media
Retention (in Days) box on the Server Properties Database Settings tab (see Figure 19-12).FIGURE 19-12
The Database Settings tab of Management Studio’s Server Properties.c19.indd 527c19.indd 527 7/30/2012 5:43:14 PM7/30/2012 5:43:14 PM
http://www.it-ebooks.info