Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MikeHinds
Starting Member
3 Posts |
 Posted - 2006-04-11 : 10:10:47
|
| I have run DBCC CHECKDB on a production database, and eliminated 95% of the Error 644s, as well as all of the Error 823s and Error 609s.It appears only three tables are still throwing Error 644. BOL entry for that error code tells me to "Identify which table and index correspond to the index page number." How can I use that info to identify which table or index to rebuild or drop/recreate?Googling, I found some fascinating but useless (to me, anyway) info refering to the undocumented DBCC PAGE, which gives my seemingly everything BUT the name of the index and table I need. |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2006-04-12 : 18:49:51
|
quote:
Originally posted by MikeHinds
I have run DBCC CHECKDB on a production database, and eliminated 95% of the Error 644s, as well as all of the Error 823s and Error 609s.It appears only three tables are still throwing Error 644. BOL entry for that error code tells me to "Identify which table and index correspond to the index page number." How can I use that info to identify which table or index to rebuild or drop/recreate?Googling, I found some fascinating but useless (to me, anyway) info refering to the undocumented DBCC PAGE, which gives my seemingly everything BUT the name of the index and table I need.
If you run DBCC PAGE (after turning on trace flag 3604) on the page output in the error message, you should find the object ID and index ID in the page header output by DBCC PAGE. Can you post the error you're getting, and the output of DBCC PAGE on that page?Thanks,--R----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
|
|
Error 644