Restoring database from .mdf and .ldf files of SQL Server 2008

  1. First Put the .mdf and .ldf file in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA folder
  2. Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box
  3. Click the “Add” button to open and Locate Database Files From C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAfolder
  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

Read More