HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Figure 86 Procedure for restoring an SQL Server database from its backup tape
Backing up an SQL Server database to tape
This section provides an example of performing an online backup of an SQL Server database onto
tape. In this example, an online backup of the INSTANCE_1 instance of the DBServer database
server is first performed to place a backup on the secondary volume, and then a backup is performed
from the secondary volume to tape. The operation ID is Operation_A. Note that when Application
Agent is used in a cluster environment, be sure to set the DRM_HOSTNAME environment variable from
the command prompt as follows before executing basic commands:
PROMPT> set DRM_HOSTNAME=virtual-server-name
Resynchronizing copy groups
When usual operation is in the split state, the copy group is first resynchronized, after which the data
is backed up.
When usual operation is in the pair status, it is unnecessary to resynchronize the copy group before
backing up the data. After the data is backed up to tape, resynchronize the copy group to restore
data to the initial state.
Operation for SQL Server databases298