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
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