Taking a Database Offline

The topic describes how in the open connection to take at least one database offline. To take a database offline:

  1. In the Database Explorer window, open the required connection.
  2. Select the database to be ignored, and right click it.
  3. Navigate to Tasks on the shortcut menu, and select Take Offline. The offline database folder has the icon now.

    Taking a database offline causes all objects that depend on that database to be taken offline.
    An offline database is not available in the Database list of the SQL toolbar.