CODEWITHSUNDEEP
azureazure-sql-database
EK_AllDay
EK_AllDay

Reputation: 1115

Azure Sql Database Read Only

I ran into a issue where I used all my credited funds for my BizSpark account. Thus my database went into read only. I removed my spending limit and attached a valid credit card. Saved my changes, however my database is still read only. How can I set it to write and read?

Upvotes: 0

Views: 3347

Answers (2)

EK_AllDay
EK_AllDay

Reputation: 1115

Once I was notified that my account reached it's cap and my database became read-only, I removed the cap. However, removing the cap does not instantly allow the database to become read only. So my impatience suggested that there was more to do after removing the cap. However, once you remove the cap, you just have to wait a few hours before the database goes back to read write.

Upvotes: 1

astaykov
astaykov

Reputation: 30903

Your DB is read-only most probably because you reached the Size Limit for the SKU. You can either (delete some records) or update the SKU.

Read more about Azure SQL Database SKUs here. And for Size here:

If the size of the database reaches its MAXSIZE, you will receive an error code 40544. When this occurs, you cannot insert or update data, or create new objects, such as tables, stored procedures, views, and functions. However, you can still read and delete data, truncate tables, drop tables and indexes, and rebuild indexes. If you remove some data to free storage space, there can be as much as a fifteen-minute delay before you can insert new data.

Upvotes: 1

Related Questions