Monitor Start-AzureSqlDatabaseCopy in Azure powershell cmdlets

Question

I'm trying to monitor an ongoing database copy, (Start-AzureSqlDatabaseCopy). I've set up the following:

$dbCopy = Start-AzureSqlDatabaseCopy -ServerName $serverName -DatabaseName $sourceDbName -PartnerDatabase $targetDbName -PartnerServer $serverName

WHILE ($dbCopy)
{
   $dbCopy = Get-AzureSqlDatabaseCopy -ServerName $serverName -DatabaseCopy $dbCopy
   Write-Host $dbCopy.ReplicationStateDescription
   [System.Threading.Thread]::Sleep(1000);
}

The state is pending (the first approx. 7 times) and then returns an exception of "resource does not exist". The database gets copied ok, but how do I monitor with script?'

This is where I got the general outline of the approach (https://stackoverflow.com/a/25268033/4261741)

Is that just what gets returned once the copy is finished? Or do you actually get a completed ReplicationStateDescription eventually? — arco444
– arco444, Commented Nov 17, 2014 at 15:46
In the while-loop, I get back a complete DataBaseCopy object with ReplicationStateDescription PENDING several times. It seems like when the status changes, I get this exception. — Muhlen
– Muhlen, Commented Nov 17, 2014 at 17:32
Yes but do you get the exception because it finished? If the copy has completed it seems reasonable that calling a Get-AzureSqlDatabaseCopy command might fail as the copy process doesn't exist any more — arco444
– arco444, Commented Nov 17, 2014 at 17:34
Yes, that's probably so. But I need to monitor when the jobs done without having try/catch handle an exception since I get the same exception if something is actually wrong. — Muhlen
– Muhlen, Commented Nov 17, 2014 at 17:39
So just add the try/catch around that single statement and examine the message property. If it's not resource does not exist then re-throw or handle some other way. — arco444
– arco444, Commented Nov 17, 2014 at 17:41

Jeffrey Bosboom · Accepted Answer · 2015-03-14 00:59:49Z

1

You can check the percentage as below.

Start-AzureSqlDatabaseCopy -ServerName $SourceServerName -DatabaseName $SourceDatabaseName -PartnerServer $TargetServerName -PartnerDatabase $TargetDatabaseName 

$i = 0

do
{
    sleep -Seconds 5
    $check = Get-AzureSqlDatabaseCopy -ServerName $TargetServerName -DatabaseName $TargetDatabaseName
    $i = $check.PercentComplete
}
while ($i -ne $null)

edited Mar 14, 2015 at 0:59

Jeffrey Bosboom

13.7k16 gold badges83 silver badges95 bronze badges

answered Mar 14, 2015 at 0:56

Sam

133 bronze badges

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

Comments

Matt Scully · Accepted Answer · 2016-08-26 22:18:04Z

0

In case anyone else comes back to this answer, if you use the new resource manager cmdlet, then you don't need to monitor progress. It blocks until the copy is complete. New-AzureRmSqlDatabaseCopy.

answered Aug 26, 2016 at 22:18

Matt Scully

4034 silver badges9 bronze badges

Collectives™ on Stack Overflow

Monitor Start-AzureSqlDatabaseCopy in Azure powershell cmdlets

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related