Geek Answers Handbook

How to stop and start the Azure SQL database?

I am launching an Azure-based site that, for historical reasons, uses two databases on two servers. I copied the data from a static data source so that both were on the same server. I am sure that I have removed all links to the old server from the live code, and in fact the Azure panel does not show any connections in the last month. But to be 100% sure, before I delete the server, I would like to stop it and test the site in real time. If something goes wrong, I would like to start it again. In SQL Server Management Studio, this is usually simple, I can right-click on the server in the SQL Server Management Studio object explorer and select "Stop", and then, if necessary, "Start". However, "Stop" and "Start" are not specified in the settings for Azure SQL Servers,and I don’t see anything on the control pages on the Azure portal.

So my question is simple - how to stop and start the Azure SQL database?

+4
source share
5 answers

as mentioned by Praggie, you cannot stop / start Azure SQL servers. Azure SQL Database is on a shared host. There are other tenants on this server. you have access to the database, but not to the corresponding hosting server.

you can rename the database, and if any application connects to it, they will fail.

+5
source

We had a problem with Sql Azure db and they were sure that it was on the server / service. We could not find the stop and start button, but found a workaround:

Scale the database to another level, and then scale it!

db.

, /... . Azure :)

+17

IP- ( , )

+7

. !

USE master;  
GO  
ALTER DATABASE MyDatabaseIsAvailable
Modify Name = MyDatabaseIsNoMoreAvailable;  
GO

, . , "" , .

+2

: . , - .

The way I found to handle this case was a read-only enforcement and immediate read of the writeback.

 ALTER DATABASE [MyDB]
 SET READ_ONLY
 WITH ROLLBACK IMMEDIATE; 

 ALTER DATABASE [MyDB]
 SET READ_WRITE
 WITH ROLLBACK IMMEDIATE;
0
source

More articles:


All Articles