Upgrading SQL Azure database size -
I'm currently in the midst of developing an application loosely of StackOverflow (Question / Answer) At the beginning, I was using ADS (ordinary DB and S3) for storage, although it raised many problems and I have chosen the option to go with SQL - eventually SQL To host on Azure.
I was just thinking, if I have selected 1 GB database initially, can I increase the size later in the 5 GB / 10 GB database? Or would I have to create a different database of this size, and close my data?
Look at my answer briefly, you modify the DB size with T-SQL, Such as:
Alternate Database MyDatabase modify (EDITION = 'WEB', MAXSIZE = 5GB)
Comments
Post a Comment