Backup and Restore Azure DB

Question

Hi Team, Automate backup and restore DB in Azure Db. The requirement is the everyday night we have to refresh DEV DB from PROD. So that our application team works on live DB. In SQL Server it is very easy to setup a SQL Agent job to perform this activity.

Answer 1

My suggestion is to do it using Azure Automation. Use PowerShell to make sure Dev database is dropped if it exists:

Get-AzureRmSqlDatabase -ResourceGroupName $ResourceGroupName -ServerName $SqlServerName -DatabaseName $databaseCopyNameRemove-AzureRmSqlDatabase -ResourceGroupName $ResourceGroupName -ServerName $SqlServerName-DatabaseName $databaseCopyName `-Force

After that create Dev database as a copy of Production.

New-AzureRmSqlDatabaseCopy -ResourceGroupName rg-resourcegroupname -ServerName sql-servername-Tags @{key="value"} -DatabaseName sqldb-databasename-CopyResourceGroupName rg-resourcegroupname -CopyServerName sql-servername-CopyDatabaseName sqldb-databasename-copy

This way refreshing the Dev environment is faster.