Information on SQL 2000 torn page repair

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Johnson Eckhoff
Best Answer
Best Answer
Answered By 0 points N/A #136185

Information on SQL 2000 torn page repair

qa-featured

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.

 
Answered By 0 points N/A #136186

Information on SQL 2000 torn page repair

qa-featured

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.

Related Questions