For some reason I have to uninstall SQL Server 2008 R2 but before that I copied two files (.mdf
and .ldf
) of my database from
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQL2008\MSSQL\DATA
Now, the question is, is it possible for me to recover the database from these files in my new installed SQL Server 2008 R2.
If yes: then how can I do this?
Best Answer
Yes, it is possible. The steps are:
First Put the
.mdf
and.ldf
file inC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
folderThen go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box
Click the “Add” button to open and Locate Database Files From
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
folderClick the "OK" button. SQL Server Management Studio loads the database from the
.MDF
file.