Restoring a SQL Database Out of Place

You can restore the database to any one of the following destinations:

• A different client from which the database was backed up

• A different path on the same client from which the database was backed up

• A different database name

When you restore a database out of place, the destination instance must be the same version or a more recent version of SQL than the source instance.

Recovery Options

The following recovery options are available:

• Recovery

  Restore a database and leave the destination database in an online state.

• No recovery

  Restore a database and leave the destination database in a restoring state.

• Standby

  Restore a database and leave the destination database in a standby state which is read-only.

Procedure

1. Access the databases that you want to restore using one of the following methods:

   1. To restore a single database to a point-in-time, complete the following steps:

      1. From the navigation pane, go to Protect > Databases, and then click the Databases tab.

         The Databases page appears.

      2. Select the database that you want to restore.

         The database page appears.

      3. Under Recovery points, select a date that contains a backup.

         Dates that are highlighted indicate that a backup exists for that day.

         Tip

         You can also select a specific time of the backup for a point-in-time restore.

      4. Click the date, and then click Restore.

   2. To restore one or more databases in an instance, complete the following steps:

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

         The Instances page appears.

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

         The Select database to restore page appears.

      3. Select the databases that you want to restore, and then click Restore.

   The Restore options dialog boxappears.

2. On the Out of place tab, do the following:

   1. From the Destination server list, select the server where the software will restore the database.

   2. From the Destination instance list, select the SQL instance where the software will restore the database.

   3. To restore to a new database, or a new path, under Data Files, make the following selections:

      • To restore to a new database, in the Destination database box, type the new database name.

      • To restore data files to a new path, in the Data file path box, type the full path name, or use the browse button .

      • To restore log files to a new path, in the Log file path box, type the full path name, or use the browse button.

3. Under Additional options, for Recovery types, select the recovery option.

4. Click Submit.