Friday, September 30, 2011

How to find the TornPageDetection/Checksum for databases in SQL 2005 & 2008

There are two different way to find checksum protection/TornPageDetection for the SQL server

--Part :1 (checksum)

select name,database_id, page_verify_option,page_verify_option_desc from sys.databases

go

-- Part :2 (IsTornPageDetectionEnabled)

select DATABASEPROPERTYEX ('master' ,'IsTornPageDetectionEnabled' )
1= TRUE

select DATABASEPROPERTYEX ('tempdb' ,'IsTornPageDetectionEnabled' )
0 = FALSE

The SQL Server Database Engine detects incomplete I/O operations caused by power failures or other system outages.
1 = TRUE
0 = FALSE