Register now or log in to join your professional community.
Is it different in SQL Server2008 &2008 R1?
Just right click on your database and go to the task menu item and there you just click detach and it is detached. Until SQL Server2012, it is the same.
Click this link to see steps for Detach a Database:
https://msdn.microsoft.com/en-us/library/ms191491.aspx
Click this link to see steps for attach a database:
https://msdn.microsoft.com/en-us/library/ms190209.aspx