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 and considerations

Consider the following before restoring 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 an MSSQL 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.

To perform a replicated SQL database restore at the target site

In this procedure, we restore replicated SQL backups from the off-site target system. The example procedure uses the following names:

     SourceBK - source backup system that protected the original SQL client (SQLBK in this example). Its backups have been replicated to the target system.

     RepTarget - target that has received replicated SQL backups from SourceBK.

     SQLBK - original SQL client. Was registered and backed up by SourceBK.

     SQLRep - new SQL client registered to RepTarget. Client to which replicated backups will be restored.

1        Perform a bare metal restore of the SQL client from the replication target as described in Bare metal recovery from a replication target.

2        On the replication target, display Replication View. See To show replication view 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 table 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 (Currently Executing Backups) blind.