HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 300)

Figure 87 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 databases 300