US : +1-877-778-6087
When your SQL database goes into the ‘suspect’ mode, you are very likely to encounter table corruption in the database. In a similar situation, you may receive the following series of errors on running DBCC CHECKDB on your database:
‘Table error: Object ID 0, index ID 0, page ID (1:13015). The PageId in the page header = (0:0)’
‘Table error: Object ID 0, index ID 0, page ID (1:13039). The PageId in the page header = (0:0)’
‘Table error: Object ID 18099105, index ID 1. Page (1:12777) is missing a reference from previous page (1:12567). Possible chain linkage problem’
These errors indicate corruption in clustered and non-clustered indexes on the specified database table. This generally happens because of disk errors due to a bad disk, controller, or cable.
To resolve the issue and repair corrupt table, you should run DBCC CHECKDB with the ‘REPAIR_REBUILD’ option or try restoring from a recent, clean database backup.
In case you are unable to fix table corruption in your SQL database and recover your precious table records, use Stellar Phoenix SQL Database Repair. The software efficiently scans your SQL database for corrupt tables and other objects, repairs them and restores these objects safely to a new database. It restores all your damaged or inaccessible database objects, including tables, keys, views, indexes, constraints, user-defined functions, and stored procedures. Using this advanced utility, you can preview these objects before saving them to your system and have an insight into the actual recovery results.
You should follow the below procedure to perform SQL Server table recovery using Stellar Phoenix SQL Database Repair
NOTE: Stop the SQL Server, copy your SQL database to a different location, and then perform repair on this copy of the database.
Stellar Phoenix SQL Database Repair is available in ‘Demo’ and ‘Full’ versions. The ‘Demo’ version provides preview of recoverable objects in the database. To save the recovered database file, you need to purchase its ‘Full’ version.