Options
What else we can do if dbcc checkdb fails in MS sql server?
lawrencehorton
Registered Users Posts: 1 ■□□□□□□□□□
in Off-Topic
MY SQL database tables are not opening.
Look on the error:
[HTML]Msg 3439, Level 12, State 34, Line 1
Table error: Object ID 2077535345, index ID 0, partition ID 72345201021503994, alloc unit ID 72345201051571606 (type In-row data), page (1:94299). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed.
[/HTML]I have found some online solutions as mentioned below:
https://www.experts-exchange.com/questions/22747262/DBCC-CHECKDB-failing-Integrity-Checks-in-maintenance-plans-on-SQL-2005-SP2.html
https://www.stellarinfo.com/sql-recovery.php
Let me know if there's anything else I can do?
Look on the error:
[HTML]Msg 3439, Level 12, State 34, Line 1
Table error: Object ID 2077535345, index ID 0, partition ID 72345201021503994, alloc unit ID 72345201051571606 (type In-row data), page (1:94299). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed.
[/HTML]I have found some online solutions as mentioned below:
https://www.experts-exchange.com/questions/22747262/DBCC-CHECKDB-failing-Integrity-Checks-in-maintenance-plans-on-SQL-2005-SP2.html
https://www.stellarinfo.com/sql-recovery.php
Let me know if there's anything else I can do?