Restoring a SQL Server database from secondary storage

You can restore the backed-up SQL Server databases from the physical LUNs (RDM, iSCSI, or FCP) on a secondary storage system. The Restore feature is a multiphase process that copies all of the data and the log pages from a specified SQL Server backup residing on the secondary storage system to a specified database.

Before you begin

You must have replicated the Snapshot copies from primary to secondary storage system.

About this task

Most of the fields on the Restore wizard pages are explained in the basic restore process. The following information describes some of the fields for which you might need guidance.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.
  2. In the Resources page, select Database or Resource Group from the View drop-down list.
  3. Select the database or the resource group.
    The database or resource group topology page is displayed.
  4. In the Manage Copies section, select Backups from the secondary storage system (mirrored or vault).
  5. Select the backup from the list, and then click restore icon.
  6. On the Location page, choose the destination volume for restoring selected resource.
  7. Complete the Restore wizard, review the summary, and then click Finish.

After you finish

If you restored a database to a different path that is shared by other databases, you should perform a full backup and backup verification to confirm that your restored database is free of physical-level corruption.