Attach Database

How to Attach a Database in SQL Server Management Studio?

· User can Attach and Database to the SQL Server from the system.

· Right-click on the Databases and select Attach.

· Click on Add button to select the MDF (Master Data File).

· Select the MDF from the location in the system where MDF is saved. This MDF can be saved in any drive like D or E or C.

· After the MDF is selected, even the log file of the Database is also selected. Click Ok.

· “New Database” will be attached to the Server under Databases.