Import MDF/LDF database into SQL SERVER 2005/2008
All you have to do import MDF/LDF files is:
1) Copy the files to you hard disk on the Server that hosting SQL Server
2) Open SQL server management studio
3) Right click on Databases, choose All Tasks, Attach Database
4) Type in the path to your MDF file (or use the ... button to browse. I should find the LDF file too if it's in the same location.
5) Give the database a name (where its says 'Attach as'.
6) Click on OK.
1) Copy the files to you hard disk on the Server that hosting SQL Server
2) Open SQL server management studio
3) Right click on Databases, choose All Tasks, Attach Database
4) Type in the path to your MDF file (or use the ... button to browse. I should find the LDF file too if it's in the same location.
5) Give the database a name (where its says 'Attach as'.
6) Click on OK.
Comments