Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I change the online status of an Azure SQL Database to offline

I want to change the status of my Azure SQL Database to offline, but cant see a way to do it from the management portal.

Thanks for reading :-)

like image 403
paulanthony Avatar asked Dec 27 '15 18:12

paulanthony


People also ask

How do I force a SQL database offline?

In the Object Explorer, select the database you want to take offline and right-click. In the right-click menu go to Tasks >> Take Offline. In the pop-up window, choose the check box under the Drop All Active Connections and click OK. The database will now taken offline.

How can I tell if SQL Server is offline or online?

A database is always in one specific state. For example, these states include ONLINE, OFFLINE, or SUSPECT. To verify the current state of a database, select the state_desc column in the sys. databases catalog view or the Status property in the DATABASEPROPERTYEX function.


1 Answers

You can add a firewall setting to deny all the IP addresses, your won't get double billed and your database is intact. The other option is rename but I wouldn't go with it unless needed.

https://msdn.microsoft.com/en-us/library/dn270017.aspx

like image 159
Sirisha Chamarthi Avatar answered Sep 17 '22 13:09

Sirisha Chamarthi