Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: SQL Server Objects > Databases > Working with Databases > Detach Databases

Detach Databases

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To detach a database

  1. Select the Databases node in the Object Explorer.

  2. Right-click a database and select Tasks | Detach Database.

  3. Complete the fields as necessary. Review the following for additional information:

    Drop Connections

    Select this checkbox to drop connections for the detached database.

    Update Statistics

    Select this checkbox to update statistics for the detached database.

    Keep Full Text Catalogs

    Select this checkbox to keep full text catalogs for the detached database.

 

Related Topics

About Databases

Attach Databases