SQL Server Database Recovery

When recovering a SQL Server database, for different cases, you should use different methods, as follows:

1. You have both .MDF and .LDF files and these files are shutdown properly. In such a case, you can just attach the database.
2. You have .MDF file but NO LDF files. The .MDF file is shutdown properly. In such a case, you can attach the database without LDF file.
3. You have both .MDF and .LDF files and these files are NOT shutdown properly. In other words, your .MDF and .LDF files are corrupt.
4. You have .MDF file but NO LDF files. The .MDF file is NOT shutdown properly. In other words, your .MDF and .LDF files are corrupt.

If you fail to use the above methods to recover your SQL Server database, then the corruption of the .MDF and .LDF is too severe, you need to use DataNumen SQL Recovery to recover the data from your MDF database.