Increase the Azure SQL Database Size Limit from 50 to 100 GB

Can I increase the size limit of an Azure database from 50 to 100 GB? if possible, what are the implications for end users and processes? that is, is the database installed offline during the change?

Will this be done using the following instructions?

ALTER DATABASE MyDatabase MODIFY (EDITION='BUSINESS', MAXSIZE=100GB) 

Thank you very much in advance.

+4
source share
1 answer

Yes, this is an instruction.

These changes should not affect database users / processes from 50 to 100 GB, you just set an upper limit

http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx

declares that the maximum size for Business Edition is 150 GB, so you should be fine.

+1
source

Source: https://habr.com/ru/post/1387957/


All Articles