You are here: Microsoft SQL Protection > SQL restore from the replication target

SQL restore from the replication target

Use this procedure if you are unable to restore from the backup system. This procedure requires that you perform a bare metal restore of the SQL client to a new client that is directly attached to the replication target. Once the client has been restored, you restore the SQL database.

Replicated SQL restore requirements

The following are required to restore from the replication target:

• A replicated bare metal backup of the source client is required.
• A replicated SQL database backup is required.
• The SQL client on the target must be running a Microsoft SQL version equal to or higher than that of the original SQL client.
• The name of the SQL instance on the new, target-side SQL client must match that of the original SQL instance.
ClosedTo perform a replicated SQL database restore at the target site

Use this procedure to restore replicated SQL backups from an off-site target system.

For illustration purposes, the steps in this procedure utilize the following terms for backup systems, targets, and clients:

• RepTarget refers to the target that has received replicated SQL backups from SourceBK.
• SQLBK refers to the original SQL client, which was registered and backedup by SourceBK.
• SQLRep refers to the new SQL client registered to RepTarget, to which replicated backups will now be restored.
• SourceBK refers to the source backup system that protected the original SQL client (SQLBK in this example). Its backups have been replicated to the target system.
1 Perform a bare metal restore of the SQL client form the replication target as described in Bare metal recovery from a replication target.
2 On the replication target, display Replication View. See Viewing replicated backups for details.

The Navigation pane contains the following:

• Brown RepTarget vault icon
• Blue RepTarget.dpu backup system icon
• Blue SourceBK backup system icon
• Blue backup icons for any other systems that are replicating to RepTarget.
3 Click the blue SourceBK backup icon, then select the SQL database under SQLRep.
4 Click Restore.
5 Select a Recovery Point Day from which the replicated backup will be restored by clicking on the calendar. Available days display in bold.
6 Select a restore time and click Next (Select Options).

Select from available times in the Recovery Point Times tables or by clicking a wedge of time on the 24-hour circle. The database instance to restore displays in the Database column.

7 In the Available SQL Servers list, select the new SQL client (SQLRep).
8 In the Select SQL Instance list, select the instance to restore. This instance name must exactly match the one on the original SQL client (SQLBK).
9 If desired, modify the Database Name. Any database with this name on SQLRep is overwritten during the restore.
10 If desired, specify a path where the database will be restored. Click Open File Browser to browse directories on the SQL client (SQLRep).
11 If desired, specify commands to run before and/or after the restore by clicking Show Advanced Execution Options. For details, see About backup options.
12 Click Restore.
13 To monitor the restore job, exit Replication View, select the replication system (RepTarget) in the Navigation pane, click Status and select the Present (Concurrently Executing Backups) blind.