Information on SQL 2000 torn page repair

Asked By Daniel Kaffe 10 points N/A Posted on - 04/24/2013

I want more detailed instruction on sql 2000 torn page repair. Can you help? First, I need to find out why a page gets damaged so I can avoid it in the future without the need to fix it and put it back in good working condition in the database.

• Status: Open
• Question Views: 1016
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Johnson Eckhoff

Go To Solution

Best Answer

Best Answer

Answered By Johnson Eckhoff 0 points N/A #136185

Information on SQL 2000 torn page repair

Hello,

If the TORN_PAGE_DETECTION option is turned on, it flips a bit for each 512-byte sector written to disk. This allows SQL Server to detect incomplete I/O operations caused by power failures or other system outages.

A torn page can occur if the system crashes between the time the operating system writes the first 512-byte sector to the disk and the completion of the I/O operation.

If the actual value read from disk is different than what’s stored in the page header, it results in a torn page error. This means there were some corruption issues. Reading a lot of posts on the web, people said it wasn’t possible to fix and should just restore from the last backup.

Following these sites which help you to know details about tone page error.

link 1: TechNet Magazine here

link 2: Repair MS SQL Database While Torn Page Error 823 Occur

link 3: Microsoft SQL Server here

 

About Johnson Eckhoff

Questions
2

Answers
52

Best Answers
19

• Vote Up 0 Vote Down

• Posted on - 05/02/2013
• Question Category: MS SQL Server

Answered By Butler Ogg 0 points N/A #136186

Information on SQL 2000 torn page repair

Hello,

First you will notice that when the option is turned on, the writing in database and updating process will be good but will be much slower than was turned off.. okay.. this option is for insurance that data were written successfully on media.

About fixing errors , I think that is good for to prevent your torn pages using battery-backed disk controllers. This makes All data will be successfully written to disk, or not written at all. And the ‘IsTornPageDetectionEnabled’ property of DATABASEPROPERTYE has more options to be set.

About Butler Ogg

Questions
2

Answers
21

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 05/05/2013
• Question Category: MS SQL Server