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

To restore (recover) backup data from tape to the secondary volume:
1. Execute EX_DRM_TAPE_RESTORE to restore the SQL Server database from tape to the secondary
volume.
2. Execute the drmsqlcat command with instA specified to check the backup ID.
3. Execute the drmsqlrestore command with instB specified as the -instance argument to
restore the SQL Server database on the secondary volume.
4. Execute the drmsqlrecover command or drmsqlrecovertool command with instB
specified to recover the SQL Server database.
Example of restoring (recovering) an SQL Server database on the log distribution destination
An example of restoring (recovering) an SQL Server database on the secondary volume is described
below.
To recover on the secondary volume:
1. If the backup catalog was not imported at the time of backup, execute the drmdbimport
command to import the backup catalog.
2. Execute the drmsqlcat command with instA specified to check the backup ID.
3. Execute the drmsqlrestore command with instB specified as the -instance argument to
restore the SQL Server database on the secondary volume.
4. Execute the drmsqlrecover command or drmsqlrecovertool command with instB
specified to recover the SQL Server database.
Example of restoring (recovering) an SQL Server database on the primary volume
An example of restoring (recovering) an SQL Server database on the primary volume is described
below.
To restore (recover) data on the primary volume:
1. If there is no data to restore (recover) on the secondary volume, restore the SQL Server database
to the secondary volume by conventional procedures.
2. Execute the drmsqlrestore command with instB specified as the -instance argument to
restore the SQL Server database from the secondary volume to the primary volume.
3. Execute the drmsqlrecover command or drmsqlrecovertool command with instB
specified to recover the SQL Server database.
Deleting backup data
If the backup data in the secondary volume is no longer necessary, you may delete it. Backup data
is deleted after being backed up from the secondary volume to tape, or restored from the secondary
volume to the primary volume.
To delete the backup data:
Application Agent CLI User Guide 385