Solved: sql database has a huge problem

Former Member · ‎01-26-2017

I opened my sql database in SQL Server 2012 and got an error: SQL Server Table Corruption Error. Does someone know for recovery sql data?

Former Member · ‎02-17-2017

When you work with sql database, all the data is copied to backup copy. Check it out. If you don’t have valid backup, then look at Recovery Toolbox for SQL Server, software supports even huge databases https://repairsql.recoverytoolbox.com/

Former Member · ‎01-31-2017

Guys, any assistance please!

Former Member · ‎02-17-2017

When you work with sql database, all the data is copied to backup copy. Check it out. If you don’t have valid backup, then look at Recovery Toolbox for SQL Server, software supports even huge databases https://repairsql.recoverytoolbox.com/

lbreddemann · ‎02-20-2017

You may want to check SAP note

1597910 - Handling of database corruptions on SQL Server

and blog https://blogs.msdn.microsoft.com/saponsqlserver/2013/10/30/corruption-handling-in-sap-databases/

Former Member · ‎06-06-2017

Have you tried the REPAIR_ALLOW_DATA_LOSS option with DBCC CHECKTABLE? If you have a current backup, I would restore the database to a NEW db, then run DBCC CHECKTABLE with REPIAR_ALLOW_DATA_LOSS on the corrupted table, and compare the old and new tables to see if anything is missing. if it fails to recover, then you can try SQL Server Table Repair Tool to fix Table Corruption Error.

​sql database has a huge problem

sql database has a huge problem