December 14, 2006 at 3:12 pm
I am running aDBCC checkdb and found a problem with one of the table and it depicts the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID -889817902, index ID 50020, page ID (1:923037). The PageId in the page header = (33739:-664239519). [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1685581043. The
How to repair a table? Will recreatring it will resolve the issue?
Any idea or advice would help.
December 15, 2006 at 12:45 am
The data corruption forum is probably a better place for this than the forum on administration of notification services. That said....
DBCC returns a statement at the bottom stating the minimum level required to fix the table.
If it says that repair_rebuild will fix the issue, then you can use DBCC CheckDB with repair_rebuild to fix the problem. (check Books online for details)
If it says that repair_allow_data_loss is required, then you have two choices. You can run checkdb with that opption however, you will loose data.
Alternativly, you can find a backup from before the corruption occurred, restore that and restore your tran logs. Good if the corruption is recent and the data critical.
It depends how critical the data is and how often it changes.
You can try and recreate the table. SQL may throw errors however.
Do you know what table it is? Looking at the object and index ids you gave, they look very wrong.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2006 at 12:04 am
Dear,
Most of the time table give errors when index pages goes wrong.
Pls read books online about DBCC checktable with the tablename.
U can repair the table with the option given for the command.
Regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply