December 20, 2015 at 6:56 am
We have backuped the databases using sql server 2012 version, but unfortunately both database and backup file got corrupted Is there any solution to restore/repair/recover the corrupted backup file/MDF/LDF files.
Regards,
Ram
December 21, 2015 at 1:24 am
Depends on the corruption
What is the full output of
DBCC CHECKDB <<DBNAME>> WITH NO_INFOMSGS, ALL_ERRORMSGS
When was your last good backup?
December 21, 2015 at 1:56 am
Post the checkDB output. Got an older backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2015 at 8:27 pm
Hi,sram24_mca,
When a MDF database file is corrupt, you can first use the SQL Server build-in command DBCC CheckDB and CheckTable to repair it, see:
and
to get more information about the commands. This is the recommended solution which you should try first.
If the corruption is severe and the above commands do not work, then you may try some third party tools to scan and recover the data from your corrupted MDF and NDF database files. Below is a list of SQL recovery tools:
The list seems to rather comprehensive that including nearly all the popular tools in the market. And all the tools provide a free demo so you can try before you purchase.
Hope this will help. Good luck!
December 22, 2015 at 8:31 pm
Hi,sram24_mca,
When a MDF database file is corrupt, you can first use the SQL Server build-in command DBCC CheckDB and CheckTable to repair it, see:
http://technet.microsoft.com/en-us/library/ms176064.aspx
and
http://technet.microsoft.com/en-us/library/ms174338(v=sql.110).aspx
to get more information about the commands. This is the recommended solution which you should try first.
If the corruption is severe and the above commands do not work, then you may try some third party tools to scan and recover the data from your corrupted MDF and NDF database files. Below is a list of SQL recovery tools:
https://www.datanumen.com/sql-recovery/compare.htm
The list seems to rather comprehensive that including nearly all the popular tools in the market. And all the tools provide a free demo so you can try before you purchase.
Hope this will help. Good luck!
December 22, 2015 at 10:20 pm
Try DBCC CHECKDB with parameters REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS to fix the corruption of your database.
If DBCC CHEKDB cannot help to solve the problem, then you can try database backup and recovery solutions which allow you to recover corrupt MDF, NDF, backup file
http://www.systoolsgroup.com/sql-server-recovery-manager.html
December 23, 2015 at 1:51 am
johnwalker10 (12/22/2015)
Try DBCC CHECKDB with parameters REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS to fix the corruption of your database.
No! No! No! No! No! No! No!!!!!!!
Suggesting what is the absolute last resort, and can lose data, without any idea of what the errors are or whether it's repairable at all is incredibly irresponsible.
For corruption, the first thing to do is to identify exactly what's wrong and then, only then, come up with a solution that will lose the least amount of data. Not just knee-jerk run something that google returned without any thought.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2015 at 7:51 pm
Hi,sram24_mca,
When a MDF database file is corrupt, you can first use the SQL Server build-in command DBCC CheckDB and CheckTable to repair it, see:
http://technet.microsoft.com/en-us/library/ms176064.aspx
and
http://technet.microsoft.com/en-us/library/ms174338(v=sql.110).aspx
to get more information about the commands. This is the recommended solution which you should try first.
If the corruption is severe and the above commands do not work, then you may try some third party tools to scan and recover the data from your corrupted MDF and NDF database files. Below is a list of SQL recovery tools:
https://www.datanumen.com/sql-recovery/compare.htm
The list seems to rather comprehensive that including nearly all the popular tools in the market. And all the tools provide a free demo so you can try before you purchase.
Hope this will help. Good luck!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply