Online Documentation for SQL Administrator for SQL Server

Detach database


Detach Database Wizard allows you to detach a database from the instance of Microsoft® SQL Server™ (with SQL Server routines used).

 

This operation is used to detach the specified database with or without updating statistics before the database is detached.

 

To run the wizard, select the Tools | DetachDatabase Detach Database... main menu item, or click DetachDatabase Detach Database... button on the toolbar.

 

The wizard consists of the following steps: