torn page

[brutus6294]

Getting a Torn Page IO error on a table. Get error when opening up table in EM (SQL 2000).Tried DBCC Checktable REPAIR REBUILD on the table - killed it after hours. No response.... Any thoughts?

 

[ptheriault]

The only other way to correct a torn page error is to restore the database from a backup. That is also what MS recommends to do. You could have data loss with DBCC. If that is ok then re-run it off hours.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

Depending on the size of the table, and the number of users who are working with the table DBCC can take a VERY long time.

DBCC should either be run after hours or the app shut down and it run now. (Now would be better so that the corruption doesn't get any worse).

Then restore the backup to another machine, and find the missing or hosed rows and restore the rows.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com