Sunday, 12 April 2015

Restoring database from .mdf files of SQL SERVER 2012

Today am going to explain today how to restore mdf file into sql server 2012.

Step1:  first we need to save the ,mdf and .ldf file save into the following folder

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

Step2: Open the sql server management studio ans select the database then choose attach

Click on Add button, it will open the file dialog box to select the .mdf file.

No comments:

Post a Comment