Azure SQL database service tier

Tigran Asatryan 26 Reputation points
2022-04-29T10:14:22.527+00:00

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.

Azure SQL Database
{count} vote

Accepted answer
  1. Alberto Morillo 34,151 Reputation points MVP
    2022-04-29T13:02:46.777+00:00

    You can easily get rid of this problem by setting a read-only lock on the database.

    197815-image.png

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. 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!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.