Try to Find That Link Again for Classification of Flights
6 Answers 6
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 :)
answered Feb 8, 2017 at 8:53
JowenJowen
4,965 1 gold badge 42 silver badges 40 bronze badges
6
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.
answered Jan 23, 2014 at 1:16
JuneTJuneT
7,810 2 gold badges 14 silver badges 13 bronze badges
1
-
it is True: you cannot restart the Azure SQL instance coz it is on a shared host. The <DBCC STACKDUMP('Manual Failover – Reason: something')> command only changes the primary instance to the default failover host.
Jun 4, 2020 at 13:15
You can simply block the IPs (remove all the firewall rules, so that no one can connect)
bummi
26.8k 13 gold badges 60 silver badges 97 bronze badges
answered Apr 29, 2015 at 4:19
A quick and dirty rename can work pretty good. Admin rights required!
USE master; GO ALTER DATABASE MyDatabaseIsAvailable Modify Name = 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
answered Jun 28, 2017 at 15:58
AurelAurel
387 4 silver badges 7 bronze badges
1
-
from where you can stop that single database?
Sep 3, 2018 at 10:24
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 WITH ROLLBACK IMMEDIATE; ALTER DATABASE [MyDB] SET READ_WRITE WITH ROLLBACK IMMEDIATE; answered Dec 13, 2017 at 13:52
SÿlSÿl
555 6 silver badges 8 bronze badges
1
-
Unless it was a coincidence of timing, this seems to have worked for me. My db was "stuck" at a status of "resuming".
May 10, 2021 at 9:45
Warning, the top google result for "restart sql server database azure" gives one of the options for restarting as running DBCC STACKDUMP('Manual Failover – Reason: something').
Running that definitely causes something to happen, but in our case after 5 minutes the DTUs still weren't registering and the portal wasn't able to pull information on the size of the database.
After waiting 10 minutes for it to come back we ended up changing the tier and roughly 18 minutes later the tier change finished and the database was accessible again.
answered May 23, 2018 at 12:59
Chris MagnusonChris Magnuson
5,460 7 gold badges 31 silver badges 33 bronze badges
Not the answer you're looking for? Browse other questions tagged sql-server azure-sql-database or ask your own question.
Source: https://stackoverflow.com/questions/21262001/how-do-i-stop-and-start-a-sql-azure-database
I wish I could double like your post :-)
Oct 23, 2017 at 4:56
Tnx @SalviPascual ! You've done anything you could have done! :)
Nov 6, 2017 at 11:32
This answer is more helpful than saying "it cannot be done". Azure, feedback for you, give the restart button please.
Dec 8, 2017 at 6:16
Scaling helped to fix an Azure SQL Database which was stuck with
Lock request time out period exceeded.Apr 4, 2018 at 18:46
Tried to do this and got
Failed to scale from Standard S1: 20 DTUs, 10 GB storage to Standard S2: 50 DTUs, 10 GB storage for database: XYZ. Error code: . Error message: The operation could not be completed because databased 'XYZ' on server 'YYY' is currently unavailable. Try again later. If the problem persists, contact customer support.Sep 3, 2019 at 17:44