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

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, click Solutions > Databases > SQL Server, and then click the Databases tab.

         The Databases page appears.

      2. Select the database that you want to restore.

         The database details page appears.

         Under Backup history, select a date that contains a backup.

         Dates with dots indicate that a backup exists for that day.

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

      3. Click the dots icon next to the time, and then select Restore.

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

      1. From the navigation pane, click Solutions > Databases > SQL Server.

         The Instances page appears.

      2. Right-click the instance that you want to restore, and then click Restore.

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

   The Restore options dialog appears.

2. Click Out of place.

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

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

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

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

7. Click Submit.