Alternatively, you can open the SQL Server Management Studio (SSMS), right-click your database, and select Tasks > Detach. There is another way to set the database offline. The following command will ...