November 16, 2007 at 3:35 pm
On a sql 2000 database I get the following message from dbcc checkdb:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:4803) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
This would appear to indicate some sort of corruption, but this problem has appeared in backup databases that are over a month old. Does not appear to be causing any problems, but was discovered today and is now an issue that needs to be corrected. I tried putting the database in single user mode and running dbcc checkdb (databaseName, repair_allow_data_loss) but got the same error message as above.
Just wondering what this error message means, and if it is possible to repair. Thanks for any help or suggestions.
Steve
November 17, 2007 at 12:47 am
Hi Steve,
This is a corrupt page at the leaf-level of the clustered index for sysindexes. It's not repairable by DBCC (or any other documented or undocumented means). The only options you have are to restore from backups (which you said you can't do) or to extract as much data as you can into a new database.
I just blogged about this error yesterday here - the post also contains a link to an explanation of the system table checks in CHECKDB that found the error.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 19, 2007 at 7:41 am
Nice explanation. Thanks for the reply.
- Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply