Recover Records from Corrupt Table

Recover Records from corrupt SQL Table

 

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.

• Start Stellar Phoenix SQL Database Repair. You will see the main interface of the software along with a dialog box.
• In the dialog box, click ‘Select Database’ to select the SQL database to be repaired. Click ‘Search Database’ to search for ‘.MDF’ files in a specific volume in the system. You can also choose to look in a specific folder by selecting the ‘Search in Folder’ option.
• Click ‘Scan File’ in the same dialog box to initiate the scan process.
• After the scan is finished, the software lists all recoverable database objects within a tree inside the left pane. You can select any object in this list to see its preview in the right pane.
• Select the required tables and other objects you need to recover and click ‘Start Repair’ icon on the tool bar. Specify your SQL Server instance name and a destination for saving the recovered file. Click ‘OK’.
• After completion of the process, the software saves the recovered database at your specified location in the system.

 

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.