Hi All,
For the pass two weeks, the DBCC CHECKTABLE with REPAIR_REBUILD option is coming out with error 2535 on certain tables. We are using SQL7 with Serive Pack 4. Please help.
Thanks,
Mary
Dear Mary,
Explanation
The DBCC CHECKALLOC statement detected a mismatch in the object ID between an allocation structure (extent) and sysindexes.
Note Occasionally, DBCC CHECKALLOC reports this error when no real error condition exists. Execute DBCC CHECKALLOC in single-user mode if you suspect the 2535 error is incorrect.
Action
Follow these steps:
Examine the index ID associated with the page number in the message to determine whether the error occurred on the table data or on an index.
Restore the database:
If the object ID is less than or equal to 100, the error is on a system table. Restore the database from a clean backup.
If the object ID is greater than 100, the error is on a user table.
If this error occurs on table data (the index ID = 1), restore the database from a clean backup.
If the error occurs on an index, you can usually correct it by dropping and re-creating the index. If dropping and re-creating the index is not feasible, or if you cannot drop the index, contact your primary support provider for assistance.
If the problem persists, contact your primary support provider for assistance. Have the output of the appropriate DBCC statements available for review.
Faheem latif
NETSOL
|||Dear Mary,
Explanation
The DBCC CHECKALLOC statement detected a mismatch in the object ID between an allocation structure (extent) and sysindexes.
Note Occasionally, DBCC CHECKALLOC reports this error when no real error condition exists. Execute DBCC CHECKALLOC in single-user mode if you suspect the 2535 error is incorrect.
Action
Follow these steps:
Examine the index ID associated with the page number in the message to determine whether the error occurred on the table data or on an index.
Restore the database:
If the object ID is less than or equal to 100, the error is on a system table. Restore the database from a clean backup.
If the object ID is greater than 100, the error is on a user table.
If this error occurs on table data (the index ID = 1), restore the database from a clean backup.
If the error occurs on an index, you can usually correct it by dropping and re-creating the index. If dropping and re-creating the index is not feasible, or if you cannot drop the index, contact your primary support provider for assistance.
If the problem persists, contact your primary support provider for assistance. Have the output of the appropriate DBCC statements available for review.
Faheem Latif
NETSOL
|||Faheem,
The object ID is greater than 100, see below, but what are the steps to fix the user table? Do I use bcp to outload the data, drop table, then load the data back?
Table Corrupt: Page (1:566656) is allocated to object ID 1189579276, index ID 255, not to object ID 798625888, index ID 5 found in page header.
Mary
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment