HP XP P9000 Replication Manager Software 7.6.0-00 Application Agent CLI User Guide

Procedure for restoring from tape directly to the primary volume
Perform the following procedure on the database server.
To restore data that was backed up to tape directly to the primary volume:
1. Execute the following command to import the file of backup information corresponding to the
data that is to be restored. This file is from among the backup information files that were output
by the drmdbexport command (the files exported as described in “Procedure for backing up
to tape on the backup server” on page 559) when backing up to tape, and which were sent from
the backup server to the database server.
PROMPT> drmdbimport -f file-name
(Create the file in the DRM_DB_PATH directory.)
2. Stop the database.
When the backup is of an SQL Server database:
If restoration does not include a system database, detach the database that is to be restored.
If restoration does include a system database, stop the SQL Server service.
If the system is in a cluster configuration, place the following resources offline: SQL Server,
SQL Server Agent, SQL Server Fulltext.
3. Delete the pair definition of the primary volume.
Execute the drmfscat command, or drmsqlcat command to confirm the volume subject to
restoration from the imported backup information. Then, using a RAID Manager command, delete
the pair definition of this volume.
4. Restore from the tape to the primary volume.
Using backup management software, restore the data from the restoration-target tape to the
backup-source primary volume.
5. Recover the database control information.
When the backup is of an SQL Server database:
Using the backup catalog stored on the backup server, restore the metafiles or control files
to the database server.
6. Recover the database.
When the backup is of an SQL Server database:
Execute the drmsqlrestore command with the -no_resync option specified.
PROMPT> drmsqlrestore backup-ID -no_resync
Execute the drmsqlrecovertool command to perform recovery.
7. Recover the pair definition of the primary volume.
Using a RAID Manager command, redefine the pair definition of the volume that is the target of
restoration.
Restoring from a tape directly to a primary volume in a Fast Snap or Snapshot configurationRestoring
from tape directly to primary volume in Fast Snap or Snapshot configuration
560