CODEWITHSUNDEEP
azurewebazure-sql-database
gimlichael
gimlichael

Reputation: 1394

SQL Azure - Change Database Edition on Master

When dropping one of the databases on our SQL Azure account and afterwards creating a new updated version of it, this was set to Business 50GB (yes, I know you can change the edition using a simple script). So far so good.

However our master database is still set to Web edition, and I don't know how to change it, as the aforementioned script does not work here.

My challenge is, that I cannot drop the server and create a new do to our current infrastructure provider who is very conservative and not willing to change firewall and DNS to the new server.

Is there a simple way to change the edition on master - or will Azure do it automatically?

My worries is, that the Web Edition (MASTER DATABASE) maybe outgrow the 5GB limit?

Thanks in advance.

Upvotes: 1

Views: 308

Answers (1)

astaykov
astaykov

Reputation: 30903

I wonder why you think you might outgrow the Master database in SQL Azure. First of all your Master Database is read-only. And it is used for storing information about all other databases (which can be up to 149, not a big number), database logins and some statistics.

From "Windows Azure SQL Database Provisioning Model":

The provisioning process creates a read-only master database automatically. The master database keeps track of which logins have permission to create databases or other logins. You must be connected to the master database whenever you CREATE, ALTER, or DROP logins or databases. The master database also provides SQL Database usage metrics that you can view.

Frankly, If you ever reach the 5G of the Master DB in Windows Azure, just contact the support, but I doubt it will happen soon.

Upvotes: 1

Related Questions