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

15. Restore the data from the secondary volume to the primary volume.
Restore the data by resynchronizing the primary and secondary volumes. To restore the data,
execute the drmsqlrestore command on the database server at the remote site. If you want
to execute the command with the template catalog backup ID specified, specify the -template
option.
PROMPT> drmsqlrestore 0000000003 -resync -template
KAVX0001-I The drmsqlrestore command will now start.
KAVX1316-I Performing restore pre-processing...
KAVX1000-I Logged on to the SQL Server system.
KAVX1300-I Restore processing will now start.
KAVX1000-I Logged on to the SQL Server system.
KAVX1301-I Restore processing has finished.
KAVX1318-I Performing restore post-processing...
KAVX1001-I Logged off from the SQL Server system.
KAVX0002-I The drmsqlrestore command will now end.
16. Apply the transaction log file.
Apply the transaction log backup file to the database to recover the SQL Server database. Execute
the drmsqlrecovertool command at the remote site database server.
PROMPT> drmsqlrecovertool default
The drmsqlrecovertool dialog box appears.
17. Recover the SQL Server database.
Recover the SQL Server database by following the instructions displayed on the dialog box.
If the past transaction log backup files were not deleted appropriately from the local site,
transaction log backup files that are unnecessary for recovery may also exist at the local site. If
this occurs, you must select the files required for recovery by referring to the creation date and
time and the name of each file before starting recovery.
18. Stop the SQL Server service at the remote site.
19. On the remote site, unmount the primary volume.
20. On the remote site, split the Business Copy pair and change the status of the Continuous Access
Software pair to PAIR.
PROMPT> set HORCC_MRCF=1
PROMPT> pairsplit -g SI11 -d sql01
PROMPT> set HORCC_MRCF=
If the primary volume is on the remote site:
PROMPT> pairresync -g TC01 -d sql01
If the primary volume is on the local site:
PROMPT> pairsplit -g TC01 -d sql01 -S
PROMPT> paircreate -g TC01 -d sql01 -vl -f never
Application Agent CLI User Guide 375