Increase Azure SQL database Data Max size in azure powershell

Question

In Prod environment for AZURE SQL database, I have S3 DTU and data max size is 10 GB. I want it to modify to 200GB, which I want to do by azure powershell script via pipeline(as other team members don't have access to PROD, so a pipeline can help).

Please help me on this. Thanks

How much research effort is expected of Stack Overflow users? — Trenton McKinney
– Trenton McKinney, Commented Sep 4, 2019 at 1:43

Jack Jia · Accepted Answer · 2019-09-04 01:25:48Z

1

First, please install the Azure PowerShell module

Then, you can use the Set-AzSqlDatabase command as following:

Connect-AzAccount
$GB = 1024*1024*1024
Set-AzSqlDatabase -ResourceGroupName "JackSQL" -ServerName "jacksql268" -DatabaseName "demodb" -MaxSizeBytes $(10*$GB)

Update

If you do not want to connect to Azure interactively, you can sign in with a service principal. This will be suitable for automation.

edited Sep 4, 2019 at 1:25

answered Sep 4, 2019 at 1:16

Jack Jia

5,5391 gold badge14 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Increase Azure SQL database Data Max size in azure powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related