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
--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