https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359368#M7494 <P>You may want to check SAP note</P><P>1597910 - Handling of database corruptions on SQL Server</P><P>and blog <A href="https://blogs.msdn.microsoft.com/saponsqlserver/2013/10/30/corruption-handling-in-sap-databases/" target="test_blank">https://blogs.msdn.microsoft.com/saponsqlserver/2013/10/30/corruption-handling-in-sap-databases/</A></P> Mon, 20 Feb 2017 01:28:47 GMT lbreddemann 2017-02-20T01:28:47Z https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359365#M7491 <P>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?</P> Thu, 26 Jan 2017 20:16:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359365#M7491 Former Member 2017-01-26T20:16:32Z https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359366#M7492 <P>Guys, any assistance please!</P> Tue, 31 Jan 2017 16:30:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359366#M7492 Former Member 2017-01-31T16:30:00Z https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359367#M7493 <P>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 <A target="_blank" href="https://repairsql.recoverytoolbox.com/">https://repairsql.recoverytoolbox.com/</A></P> Fri, 17 Feb 2017 21:00:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359367#M7493 Former Member 2017-02-17T21:00:15Z https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359368#M7494 <P>You may want to check SAP note</P><P>1597910 - Handling of database corruptions on SQL Server</P><P>and blog <A href="https://blogs.msdn.microsoft.com/saponsqlserver/2013/10/30/corruption-handling-in-sap-databases/" target="test_blank">https://blogs.msdn.microsoft.com/saponsqlserver/2013/10/30/corruption-handling-in-sap-databases/</A></P> Mon, 20 Feb 2017 01:28:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359368#M7494 lbreddemann 2017-02-20T01:28:47Z https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359369#M7495 <P>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 <A target="_blank" href="http://www.sqlrecoverytool.com/">SQL Server Table Repair Tool</A> to fix Table Corruption Error.</P> Tue, 06 Jun 2017 10:02:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-database-has-a-huge-problem/m-p/359369#M7495 Former Member 2017-06-06T10:02:32Z