How to Attach and Detach a Database
Sometimes you want to transfer or backup your database in SQL Server. When the database is attached you cannot copy/move it to any location. All you have to do is detach it first using SQL Server Management Tools.
Another reason why I write this tutorial is to teach you so that when we finish the Library System project you will be able to switch from my own database to your own database just in case you want to differentiate each of the table.
To attach a database
1. Open SQL Server Management Tools.
2. Right click Database and click Attach.