TORN_PAGE_DETECTION

if one of the database says 'TORN_PAGE_DETECTION', is it of concern? what could be done to make it CHECKSUM again?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
aelliso3Commented:
you can change it back with the following ... I haven't heard of it changing by itself before.
ALTER DATABASE SomeDB SET TORN_PAGE_DETECTION OFF
0
 
aelliso3Commented:
you can also do it through the GUI if you prefer,
Right click on the database --> Go to Properties --> Select Options
Go down to Recovery --> Page Verify        and select whichever you want
0
 
anushahannaAuthor Commented:
so there is nothing to be concerned about that option/setting?

what is the disadvantage if it is still operating in that mode?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
aelliso3Commented:
there is a very small difference between torn page detection and checksum. The only one that I can really think of is that torn page detection does not detect corruption within sectors. Checksum uses a very very small amount more CPU, but the benefits are worth that little bit.
 
0
 
anushahannaAuthor Commented:
OK. Thanks.

ALTER DATABASE SomeDB SET TORN_PAGE_DETECTION OFF
puts the DB to 'NONE'. How would you bring it to CHECKSUM?
0
 
aelliso3Commented:

ALTER DATABASE SomeDB SET PAGE_VERIFY CHECKSUM
0
 
anushahannaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.