Azure SQL Database Restore

With this task, you can restore an Azure SQL Database to another Azure SQL Database on the same server using the latest point-in-time backup.

Requirements

You should have Setup an Azure Resource Manager Endpoint to use this task.

Add the task to your Build or Release Definition

You will find the task in the "Deploy" category.

Configuration

General

• Azure RM Subscription - Specifies the Azure Resource Manager Service Endpoint to use.
• Azure SQL Server Name - Azure SQL Server name like, FabrikamSQL.database.windows.net,1433 or FabrikamSQL.database.windows.net.
• Source Database Name - Name of the source Azure SQL Database from which to restore.
• Target Database Name - Name of the target Azure SQL Database. If exists, will be deleted prior to restore!