Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

no page verification or torn page verification

Posted on 2014-11-17
1
Medium Priority
?
200 Views
Last Modified: 2014-11-18
Can anyone provide a management friendly low tech summary of the risks you may encounter if a database (seems to be configured in sys.databases) has either no page verification or torn page verification. The recommendation appears to be CHECKSUM. Please elaborate on the risks in using either none or torn page?
0
Comment
Question by:pma111
1 Comment
 
LVL 70

Accepted Solution

by:
Scott Pletcher earned 2000 total points
ID: 40447633
The risk of "NONE" is that potentially all data from certain table(s) is unreadable and thus lost.  You can't predict which tables it will be.  In short, NONE is just nuts.

CHECKSUM is more thorough, and helps you more quickly identify bad disk writes that are corrupting a db.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question