Powershell script increasing Azure SQL Database storage size with 10%

Question

I need to create powershell script that will increase Azure SQL database storage space with 10%. With GB its not a problem, but I don't have an idea how to do it with %. I have something like that:

$1 = Get-AzSqlDatabase -ResourceGroupName "testRG" -ServerName "test-sql" -DatabaseName "test-sqldb"
$2 = $1.MaxSizeBytes

But how to point that MAxSizeBytes will be 100% and add 10% more ?

Peter Schneider · Accepted Answer · 2020-06-18 13:47:55Z

1

You have to use Set-AzSqlDatabase and set the parameter -MaxSizeBytes to the desired value.

Should be something like:

$db = Get-AzSqlDatabase -ResourceGroupName "testRG" -ServerName "test-sql" -DatabaseName "test-sqldb" 

Set-AzSqlDatabase -ResourceGroupName "testRG" -ServerName "test-sql" -DatabaseName "test-sqldb" -MaxSizeBytes $($db.MaxSizeBytes*1.1)

You probably have to check the valid sizes in Azure Portal. According to this post the values are limited to specific sizes.

edited Jun 18, 2020 at 13:47

answered Jun 18, 2020 at 13:41

Peter Schneider

2,9591 gold badge16 silver badges19 bronze badges

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

1 Comment

Riley Carney Over a year ago

Check size, check if actually found actual database, etc. 😂

Collectives™ on Stack Overflow

Powershell script increasing Azure SQL Database storage size with 10%

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related