Travis Tran

Travis Tran

BREAKTHROUGH the limits

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

  1. First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ 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 Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\folder
  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

 

X
Glad to have you at travistran.me
Welcome to TravisBot
wpChatIcon