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