See How You can Attach an MDF File

SQL Server by default stores its databases in two files, which are as follows:

  • MDF File: The MDF file is actually the primary data file, which contains table schemas, tables, and data
  • LDF File: The LDF file is the file containing the logs for the database

It is good if you have both files (MDF file and LDF file) attached to the SQL Server instance, but for you, it is possible only to attach the MDF file, and the SQL server will itself create an LDF file for that database.

  • Manage database in the SQL Server calling it “Demand”. The command you need to problem in Window.
  • Find out Someplace the MDF and LDF files are really stored on the hard disk of your system:

  • You have to detach these MDF files from the Server case: sp_detach_db Demand
  • Now, you should open the place somewhere these database are stored. You can also remove the require.LDF file or you can modify its name.
  • After that, you can connect the MDF file to the MS SQL server case. You can do this by issuing the following command in a query Window (keep the database name and file path according to your requirement):

SQL Server Recovery Software

f you have any problem for recovery of SQL Server sMDF File which are corrupted then use third party SQL server Database Recovery Tool. SQL Recovery Software recovers all types of SQL database without any problem.


Download Purchase