ALTER DATABASE [DATABASENAME] SET OFFLINE

by Nov 4, 2012

Does the ability to bring a database offline via the GUI exist in ADS? I can’t seem to find it and am wondering if I’m just missing something.

Response

Niels Gron over 10 years ago
In Aqua Data Studio you can right click on Server -> DBA Tools -> Storage Manager. In the Storage Manager right click on the Database -> Set Online option.
If the database is online it will ask if you want to take it offline.
If its offline it will ask if you want to take it online.

In SQL Server Management Studio you can use the tree by right clicking on the database-> task -> set database [ONLINE|OFFLINE]. We have plans on moving the actions from the Storage Manager to the schema tree in a future version.