[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 724
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
  • 4
  • 3
2 Solutions
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now