SQL database recovery from corrupt database file!?

Question

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.
Does anyone know what causes this? I'm suspecting corruption here (it's just a suspicion as I'm not sure). Please help me. The copies of my databases are very crucial.
Many thanks in advance.

Answer 1

Hi



If you are using SQL Server, then you can face corruption issue in your SQL Server database. In this situation, you no need to be anxious; you can easily solve this issue with an advance tool. I am going to introduce about such tool which is well known as SQL Server Repair Kit that can quickly repair corrupted or damaged MDF file from SQL Server 2012, 2008, 2005 & 2000 without harm your data integrity.



Check this out:- http://www.mssqlserver.repair/



If you need to manually restore an SQL Database in Management Studio you can follow the instructions below for the version of SQL Server running on your server.



SQL 2012:



1. Log onto SQL Server Management Studio.

2. Navigate to the database you wish to restore.

3. Right Click > Tasks > Restore > Database.

4. Once on the General tab set the source to Device > Select Backup Device > Add > Navigate to the .bak file you're restoring to.

5. Ensure The Destination Database is the correct one.

6. Select the Options tab.

7. Check "Overwrite the existing database (WITH REPLACE)" and "Close existing connections to destination database".

8. Uncheck "Take tail-log backup before restore".

9. Click OK.



Regards

Answer 2

SQL Server database and recovers inaccessible objects in MDF and NDF database files. The software carries out the highest level of non-destructive repair to preserve database integrity.



Try:- http://www.pcrecoveryutility.com/sql-database-recovery.html

Answer 3

Run below syntax to check your backup:

RESTORE VERIFYONLY FROM DISK = 'D\backup\databaseName.Bak'

GO



RESTORE VERIFYONLY has been enhanced to do additional checking on the data to increase the probability of detecting errors.



If there is any errors or corruption then please continue restore with 'CONTINUE_AFTER_ERROR' to restore corrupted backup.



Database may be inconsistent afterwards CONTINUE_AFTER_ERROR, so you need to use REPAIR_ALLOW_DATA_LOSS.



There is a 3rd party tool also that repairs corrupt SQL server backup file.

Answer 4

You can also use SQL database recovery software from http://www.en.sqldatarecovery.org which recovers over-sized MDF file. It recovers corrupt or inaccessible SQL Server database and recover deleted or lost SQL tables & data from corrupt MDF file. You can export required database from MDF & NDF files.