The detached database is removed from SQL Server instance but it remains uncorrupted and keeps all its files and transaction logs. These files can later be used to attach the database to any SQL Server instance including the sever from which it has been detached.
You can detach a database only if there are no current connections with it and if it is not used in the replication process.
You can detach the database from the server in one of the following ways:
- Choose Services | Detach Database in the main program menu and define the necessary settings in the opened wizard.
- Choose Tasks | Detach Database in the context menu of the Databases group and define the necessary settings in the opened wizard.