How Do I Stop And Start A Sql Azure Database?

I am running an Azure based site that for historic reasons uses two databases on two servers. I have copied the data from the static data-source so that both reside on the same ser

Solution 1:

We had an issue with a Sql Azure db and were pretty sure it was in the server/service. We couldn't find the stop & start button, but did find a workaround:

Scale the database to another tier and then scale it back!

It solved our db issue.

Everybody says you don't need a stop/start button... but sometimes the theory differs from practice. Even Azure has issues :)

Solution 2:

as Praggie mentioned, you cannot stop/start the SQL Azure servers. A SQL Azure Database resides on a shared host. there are other tenants on that server. you have access to the database, but not to the corresponding hosting server.

you can rename the database and if there's any app connecting to it, then they'd fail.

Solution 3:

You can simply block the IPs (remove all the firewall rules, so that no one can connect)

Solution 4:

A quick and dirty rename can work pretty good. Admin rights required!

USE master;  
GO  
ALTER DATABASE MyDatabaseIsAvailable
ModifyName= MyDatabaseIsNoMoreAvailable;  
GO  

do the opposite once you're done. The good thing is you can 'stop' a single Database when you have more than one on the same server

Solution 5:

If this helps: in my situation, the database was locked. I could not alter tables, schema or anything else.

The way I found to handle this case was forcing read only and read write with rollback immediate.

ALTER DATABASE [MyDB]
 SET READ_ONLY
 WITHROLLBACK IMMEDIATE; 

 ALTER DATABASE [MyDB]
 SET READ_WRITE
 WITHROLLBACK IMMEDIATE;