Online Documentation for SQL Manager 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 Services | Detach Database... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | Detach Database... item of the context menu.

• Setting connection properties
• Selecting the database
• Detaching database