Perform a Test Backup and Restore for Azure SQL Instance

To verify that Azure SQL instance is set up correctly, perform a test backup and restore.

Back Up the Instance

1. From the navigation pane, go to Protect > Databases.

   The Overview page appears.

2. On the Instances page, in the row for the instance, click the action button , and then click Back up.

   The Backup options dialog box appears.

3. Click Submit.

Restore the Database

1. From the navigation pane, go to Protect > Databases.

   The Overview page appears.

2. On the Instances page, in the row for the instance, click the action button , and then click Restore.

   The Backup content dialog box appears.

3. Select the backup, and then click Restore.

   The Restore options dialog box appears.

4. Click Submit.