MS SQL Server: how can I restore database from .mdf and .ldf files

Question

I had to format my PC where I had my SQL server installed. Before formatting, I took the backup of my databases (.mdf & .ldf files). Now, I installed all the software on my machine and want to restore my databases. How can I restore the databases using the backup .mdf and .ldf files?

Answer 1

If you have installed MS SQL server management studio on your machine, follow the following steps to restore your databases:

1. Move your .mdf and .ldf files to the DATA folder of your SQL server.

2. Login to your SQL server from MS SQL server management studio -> Right-click "Databases” -> click “Attach”  option to open the Attach Databases dialog box.

3.Click the “Add” button to open and Locate Database Files from the DATA folder of SQL server.

4. Click the "OK" button. SQL Server Management Studio will load the database from the .MDF file.