Powershell runbook is giving timeout error while copying the Azure SQL database

Question

I'm using a PowerShell script to create a copy of an Azure SQL Database (Database1) using the New-AzSqlDatabaseCopy command. However, the runbook times out during execution. I'd like to know:

Does the database copy operation continue in the background even after the runbook times out?

If the copied database (Database1_2025050223) appears, how can I be sure it contains the full data from the source (Database1) and not a partial copy?

Here is the command I'm using:

New-AzSqlDatabaseCopy -ResourceGroupName 'RGName' -ServerName 'RGName' -DatabaseName 'Database1' -CopyResourceGroupName 'RGName' -CopyServerName 'RGName' -CopyDatabaseName 'Database1_2025050223'

Hi M.Tharun Kumar, The database copy is asynchronous. Once the request is accepted, the target DB is created and the copyStarts in the background. To verify: Log in to the new server/database. Compare the size of the source and copied DBs. Check if all tables are copied by querying them (e.g., SELECT * FROM dbo.TableName). — Narendra Reddy Pakkirigari
– Narendra Reddy Pakkirigari, Commented May 7 at 6:49

Narendra Reddy Pakkirigari · Accepted Answer · 2025-05-07 12:06:59Z

1

Powershell runbook is giving timeout error while copying the Azure SQL database

The database copy is asynchronous. Once the request is accepted, the target DB is created, and the copy continues in the background.

To verify the copy:

connect to the new server/database, compare DB sizes, and run queries

SELECT * FROM dbo.[YourTableName];

to confirm table and data consistency.

answered May 7 at 12:06

Narendra Reddy Pakkirigari

1666 bronze badges

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

Collectives™ on Stack Overflow

Powershell runbook is giving timeout error while copying the Azure SQL database

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