changing page verifacation

pma111
pma111 used Ask the Experts™
on
is there any specific best practices on how and when to change page verification in MSSQL from torn page to checksum - and any specific precautions we should take before/after if it causes issues? is it a lengthy process to change or a very "quick fix"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
Quick - the setting is applied only if the page is changed. No precaution. checksum is the recommended page verification method as it is better for detecting damaged pages.
You just set it at the database level (database properties).

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial