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

Backing up transaction logs in a cascade configuration without a backup catalog
This section explains the steps for backing up transaction logs in a cascade configuration when the
backup catalog does not exist.
Here, because the starting point for backing up transaction logs is an SQL Server database that is
backed up only to a secondary volume of a remote site by the drmsqlbackup command with the
-script option, the -no_cat option is used.
• Back up the transaction logs.
Back up the transaction logs. To back up the transaction logs, execute the drmsqllogbackup
command on the database server at the local site.
PROMPT> drmsqllogbackup default -no_cat
KAVX0001-I The drmsqllogbackup command will now start.
KAVX0002-I The drmsqllogbackup command will now end.
Restoring an SQL Server database in a cascade configuration
This section explains the steps for restoring SQL Server database data, which was backed up from
the remote site secondary volume to tape, to the local site (restoration in a cascade configuration).
To restore an SQL Server database in a cascade configuration:
1. Stop the SQL Server service at the local site.
2. Unmount the secondary volume at the local site.
3. Perform takeover.
If the local site primary volume can communicate with the remote site secondary volume (for
example when the current and standby systems are intentionally switched), use the horctakeover
command to perform takeover. This step must be performed at the remote site.
PROMPT> horctakeover -g Cnt Ac01 -d sql01
4. Split the Continuous Access Software pair (usual operation is in the pair status).
To split a Continuous Access Software pair whose usual operation is in the pair status, execute
the pairsplit command at the remote site.
PROMPT> pairsplit -g Cnt Ac01 -d sql01 -rw
Operation for SQL Server databases370