Restoring a SQL Database Out of Place

You can restore the database to a database with a different name, to a different path on the same instance, or to a different instance.

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.

Procedure

Access the databases that you want to restore using one of the following methods:
- To restore a single database to a point-in-time, complete the following steps:
  1. From the navigation pane, go to Protect > Databases.
    
    The Overview page appears.
  2. On the Databases tab, 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.
    
    The Restore options dialog box appears.
- To restore one or more databases in an instance, complete the following steps:
  1. From the navigation pane, go to Protect > Databases.
    
    The Overview page appears.
  2. On the Instances tab, in the row for the instance that has databases that you want to restore, click the action button , and then click Restore.
    
    The Backup content page appears.
  3. Select the databases that you want to restore, and then click Restore.
    
    The Restore options dialog box appears.
Select Out of place.
From the Restore type list, select Cross instance restore.
From the Destination server list, select the server where the software will restore the database.
From the Destination instance list, select the SQL instance where the software will restore the database.
To restore to a new database, or a new path, under Redirect options, do the following:
1. In the row for the database that you want to change the location on the destination server, click the action button .
  
  The Edit database options dialog box appears.
2. In the Database name box, type a name for the new database.
3. In the Data file path box, enter the path for data file.
4. In the Log file path box, enter the path for log file.
5. Click Save.
Under Additional options, from the Recovery types list, specify the state to leave the restored database in:
- Recovery: The online state.
- No recovery: The restoring state.
- Standby: The standby state (which is read-only).
Click Submit.