Azure SQL Database
An Azure relational database service.
5,838 questions
You can easily get rid of this problem by setting a read-only lock on the database.
Azure SQL database service tier
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 6%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tigran Asatryan
26
Reputation points
Hello guys,
I created a Azure SQL database and selected the 5 (Basic) service. Every day this service tier reset to Gen5 service tier automatically and I set it back to 5 (Basic) manually. How to fix the 5 (Basic) to be a permanent?
Thanks in advance.
{count} vote
-
Olaf Helper 45,366 Reputation points2022-04-29T10:33:15.973+00:00 You should better use the right tag azure-sql-database (https://learn.microsoft.com/en-us/answers/topics/25398/azure-sql-database.html) ; tag SSRS is completly wrong.
-
Tigran Asatryan 26 Reputation points
2022-04-29T11:01:43.177+00:00 Thanks
Sign in to comment
Accepted answer
1 additional answer
Sort by: Most helpful
-
Tigran Asatryan 26 Reputation points
2022-05-03T09:32:51.907+00:00 Thank you very much, I tested the lock and it works great!
-
Alberto Morillo 34,151 Reputation points MVP2022-05-03T10:26:15.473+00:00 Thank you for visiting Microsoft QA forums. Have a wonderfu day!
-
GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee2022-05-03T14:53:14.133+00:00 @Tigran Asatryan Thank you for your feedback, please accept the answer, This will help other community members facing similar queries to refer to this solution
Thanks, @Alberto Morillo for your support.
Regards
Geetha -
Alberto Morillo 34,151 Reputation points MVP
2022-05-03T21:17:37.39+00:00 Thank you @GeethaThatipatri-MSFT !
Sign in to comment -