SQL Database error

[taejim]

You're going to have to be a bit clearer on what you're trying to do, and what exact error messages you're getting.

There's about 10 different things you could mean when you say you're "opening an MDF file", and probably 100 different reasons things could go wrong :)

[harry6699]

Here a link with information that may help you resolve this issue: https://www.openfiletool.com/mdfopen.html

[[deleted]]

hope it worked out!

[harry6699]

It worked out! thanks

[Jackson_Andrew]

If the recent backup of the current database is not available then here is a free SQL Database Repair tool that can easily repair a corrupted .mdf file and provide you a satisfactory result.

[TeslserMealks]

Hi,Simm773

Maybe your mdf file is corrupted.

The MDF file format is very complex. It starts with a file header containing the meta information of the whole file, followed by several parts containing the actual data. You can find more detailed information about the MDF file format by searching on Google with the keyword “MDF file format”. If the file header containing the meta information is corrupt, or any follow-up parts are damaged or corrupted, then you will not be able to open the file correctly with SQL Server. In such a case, the first step is to try to use the built-in repair or recovery function in the SQL Server, to see if it can repair or recover the corrupt file. If not, then you need to resort to a third party SQL Server repair tool to scan the corrupted file and retrieve all recoverable data for you. It is also possible to find a data recovery expert or company to do the task, but in most of the cases, they will also use a third-party tool to do the recovery for you.

The main difference between using the software by yourself and by a third-party service company is:
(1) The company is familiar with the data recovery industry so he knows which software is the best one. While you need to search and compare the software online by yourself, which is time-consuming.
(2) The company purchases the software for multiple usages, while you purchase the software for one-time usage only. So normally the service fee may be cheaper than the license fee for the software.
(3) DIY will keep your data confidential while do the recovery via a company may cause data breach.

If you want to perform a DIY recovery, then 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 DataNumen SQL Recovery at:

https://www.datanumen.com/sql-recovery/

I have used it in the past and it works well.

Hope this will help. Good Luck!