I am a CTO with over 5 years of experience in start-up and over 10 years in working at managing position for big companies. I am also a full-stacks developer with over 12 years in system design, product development and technology product deployment.User experience and system security are the things I care about most.

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

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.

 

Share this
Send this to a friend