beautypg.com

Restoring an sql server replica to a remote site, Recovering a database from a remote site to local – HP XP P9000 Command View Advanced Edition Software User Manual

Page 395

background image

3.

Expand the object tree, and then select a database server.

The Server summary window appears.

4.

Open the Replica History tab to view a list of replicas.

5.

Select a replica and click Restore Replica.

The Restore Replica Wizard is launched.

6.

Follow the procedure in

Restoring the latest application replica (simple restore)

” on page 393

starting at step 5.

Related topics

Restoring the latest application replica (simple restore)

, page 393

Creating an application replica

, page 386

Restoring an SQL Server replica to a remote site

This topic explains how to restore an SQL Server application replica to a remote site and recover the
restored database to a local site.

To restore an SQL Server replica to a remote site:

1.

Select a copy group, start the Change Pair Status Wizard, then delete a copy pair (or pairs).

2.

Restore the database from tape as described in

Performing tape backups and

restores

” on page 408, but do not run the Restore Replica Wizard at this point.

3.

Use the Disk Management function to mount a volume connected the the backup server.

NOTE:

If the secondary volumes are concealed, follow the procedure in “

Revealing secondary

volumes prior to a remote restore operation

” on page 396.

4.

Start the SQL Server instance on the backup server.

5.

In the Applications view, open the Hosts list and select the server. In the Replica History tab, select
the replica to be restored and start the Restore Replica Wizard.

6.

On the 1. Select Target page, select the target to be restored.

7.

On the 2. Setup Options page, set the target server as the backup server.

8.

Complete the Restore Replica Wizard and use the Tasks List window to check the results of the
restore operation.

9.

If necessary, follow the procedure “

Recovering a database from a remote site to local

” on page 395.

Related topics

Restoring an application replica from the Replica History

, page 394

Recovering a database from a remote site to local

To recover the database from the remote site:

1.

Stop SQL Server on the database server.

User Guide

395

This manual is related to the following products: