Attach Database In Sql Server 2014 Step By Step

In this post we will learn how to attach a database in sql server 2014. We will use our library database for example. If you didn’t download the database you can download from here.

1. First extract the LibraryDatabase file
2. Copt the library.mdb and library_log.ldf files to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA folder.If the program asks you for administrator permission, click the yes button.
3. Than run the sql server 2014 and connect the database.
4. Right Click databases at Object Explorer toolbar.

6. Then Click Attach…

7. Then Click Add Button…

8. Make sure it is in the Data folder: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA

11. Select Library.mdf and Click OK button.
12. You will see the database’s files at the bottom.(Library.mdf and library_log.ldf)
13. When you click OK button the library database will be list in Object Explorer Toolbar / Databases.
14. That is all. You can use the database right now.