{"id":95198,"date":"2022-03-04T12:02:56","date_gmt":"2022-03-04T12:02:56","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=95198"},"modified":"2023-01-23T10:59:32","modified_gmt":"2023-01-23T10:59:32","slug":"how-to-get-data-from-corrupt-sql-table","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/how-to-get-data-from-corrupt-sql-table\/","title":{"rendered":"How to Get Data from a Corrupt SQL Table?"},"content":{"rendered":"

A table in the SQL database can get corrupt due to storage issues, like insufficient space on the drive, bad sectors on the drive, etc. Besides this, a malware attack, sudden system shutdown, and accidental data deletion are other factors that may cause table corruption. Running DBCC CHECKDB<\/a> can help you detect corruption in the table. For instance, a table corruption error looks something like this:<\/p>

\"sql<\/figure>

Methods to Get Data from Corrupt SQL Table<\/strong><\/h2>

Use the below-given methods in the same sequence to extract as much data as you can from the corrupted table. However, to avoid losing any data, consider using a SQL recovery tool<\/a>.<\/p>

Method 1 – Run DBCC CHECKDB Command with Repair Option<\/strong><\/h3>

As you can see in the error message above, repair_allow_data_loss is suggested as the minimum level of repair to fix the error. Run DBCC CHECKDB with the repair option for the corrupt table (as given below).<\/p>

dbcc checkdb (table_name, repair_allow_data_loss)<\/td><\/tr><\/tbody><\/table><\/figure>

Replace ‘table_name’ with the name of the problematic SQL table. If this doesn’t work, try the next method.<\/p>

Method 2 – Move Data from Corrupt Table to New Table<\/strong><\/h3>

Note:<\/strong> This method will only work if the database is accessible. If the database is also affected, use method 3.<\/p>

Script out all objects in the current database and create a new database with a new table. Move all the data except for the corrupt table to the new database. Once you are done, try moving the data out of the table into the new one. The detailed steps are as follows:<\/p>