Sunday, February 19, 2012

Error 2535

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
MaryDear Mary
Explanatio
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
Actio
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
Explanatio
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
Actio
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 Lati
NETSOL

No comments:

Post a Comment