Solved

no page verification or torn page verification

Posted on 2014-11-17
1
192 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

635 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