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 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 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.

Loading...