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

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 BC11 -d sql01
PROMPT> set HORCC_MRCF=
If the primary volume is on the remote site:
PROMPT> pairresync -g Cnt Ac01 -d sql01
If the primary volume is on the local site:
PROMPT> pairsplit -g Cnt Ac01 -d sql01 -S
PROMPT> paircreate -g Cnt Ac01 -d sql01 -vl -f never
21. Perform takeover at the local site to change the local site to the primary volume.
Execute the horctakeover command at the local site.
PROMPT> horctakeover -g Cnt Ac01 -d sql01
22. At the local site, mount the primary volume and start the SQL Server service.
When performing this step, note the following point.
A transaction log backup file is associated with the backup catalog that was created for the last
complete backup of the SQL Server database. However, if this last backup was performed with NO
assigned to LOCAL_BACKUP in the user script file, no backup ID was assigned. Therefore, when the
log backup information is displayed by executing drmsqllogbackup with the -v option specified,
the backup catalog and the transaction log file do not correspond, and the information cannot be
used for a recovery. In this situation, use the drmsqlrecovertool dialog box to select transaction
log backup files that are needed to perform recovery operations and perform the recovery operations.
Operation for SQL Server databases374