question

chitrarekha.saha avatar image
chitrarekha.saha asked

Torn_Page_Detection and Checksum

I have some databases with compatible level sql Server 2005 with Page Verify Torn_Page_Detection, can I change that to checksum? However if the database has compatible level 2000, can I keep the Page verify to Torn Page Detection?
sqlserver 2008r2
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
It's a database setting, so the answer is -- yes, you can -- for both of your questions. In regards of CHECKSUM, please read [A SQL Server DBA myth a day: (17/30) page checksums][1] for some common misconceptions regarding the CHECKSUM setting. [1]: http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1730-page-checksums/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.