Perform a Test Backup and Restore of the SQL Server Instance

Updated

To verify that the SQL Server 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 Instances page appears.

  2. In the row for the instance, click the action button action_button, and then click Backup.

    The Backup options dialog box appears.

  3. Click Submit.

Restore the Database

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

    The Instances page appears.

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

Was this page helpful?