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

## Prerequisites for configuring additional disks

If the destination does not have existing SQL data file paths, attach uninitialized local disks to the destination client before you run the restore. Attach the same number of disks as the source database has data disks, and make each disk equal to or larger than the corresponding source disk. The destination client must have been restored from a VM backup.

## 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 Command Center navigation pane, go to Protect > Databases.

      2. Click the Databases tab.

         The Databases page appears.

      3. Select the database that you want to restore.

         The database page appears.

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

      5. Click the date, and then click Restore.

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

      1. From the Command Center 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 box appears.

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. If the destination does not have existing SQL data file paths, under Advanced options, enable Configure additional disks.

   The software detects the attached disks, creates the required file paths, and then restores the database.

5. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

   1. Click Schedule.

      The Add schedule dialog box appears.

   2. In the Name box, type a name for the schedule.

   3. Configure the Frequency and Repeat parameters.

   4. To specify exceptions to the schedule, click Exceptions.

      The Exceptions dialog box appears.

   5. Configure the exception parameters:

      - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

      - Click Save when you have finished configuring the exception parameters.

   6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

   7. To save the schedule and return to the restore dialog box, click Schedule.

6. Click Submit.

×

Loading...