Quick Scan Report – Obsolete Torn Page Detection

The Quick Scan Report has detected that you are using the obsolete page verify mode called Torn Page Detection.

Torn Page Detection has been obsolete since SQL Server 2005, last really recommended in SQL Server 2000. The recommendation for SQL Server 2005 and newer is to us the CheckSum option as the page verification type.

page_verify_options Torn Page Detection
Don’t use Torn Page Detection, use CHECKSUM

 

 

 

Related Links:


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!