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

12. Create a user script file.
To obtain the information required to create a user script file, execute the drmsqldisplay
command on the database server at the local site. For details on how to create a user script file,
see “Creating a User Script to Perform a Backup in a Cascade Configuration” on page 356.
PROMPT> drmsqldisplay default -remote
INSTANCE: default
T DB OBJECT FILE L-COPY-GROUP R-COPY-GROUP PORT#
TID# LUN# MU# LDEV# P/S SERIAL#
D UserDB1 DATAFILE Z:\UserDB1_Data.MDF - - CL1-A
1 32 - 32 P 116
- - - - BC01,sql01 - CL1-A
1 60 0 60 S 116
- - - - Cnt Ac01,sql01 - CL1-A
1 32 0 32 S 600
- - - - Cnt Ac01,sql01 Cnt Ac01,sql01#0
- - - 0 60 C 600
T UserDB1 TRANSACT Z:\UserDB1_Log.LDF - - CL1-A
1 32 - 32 P 116
- - - - BC01,sql01 - CL1-A
1 60 0 60 S 116
- - - - Cnt Ac01,sql01 - CL1-A
1 32 0 32 S 600
- - - - Cnt Ac01,sql01 Cnt Ac01,sql01#0
- - - 0 60 C 600
PROMPT>
13. Stop the SQL Server service and unmount the Continuous Access Software pair volume at the
local site.
14. To change the secondary volume at the remote site to the primary volume, perform takeover.
To perform takeover, execute the RAID Manager command horctakeover at the local site.
PROMPT> horctakeover -g Cnt Ac01 -d sql01
PROMPT> pairsplit -g Cnt Ac01 -d sql01 -rw
15. Mount the Continuous Access Software pair volume at the remote site and start the SQL Server
service.
16. Create a database configuration definition file at the remote site.
To create a database configuration definition file, execute the drmsqlinit command on the
database server at the remote site. Specify the same information you specified for the local site
in step 1.
PROMPT> drmsqlinit default
KAVX1100-I Enter the name of the storage directory for VDI metafiles:
KAVX1101-I Enter the timeout interval for VDI generation (in seconds, between 0 and 3600):
KAVX1102-I Enter the name of the storage directory for undo files: E:\MSSQL\DEFAULT\undo
KAVX1107-I Enter the name of the storage directory for backup-log files: E:\MSSQL\DEFAULT\tlog
KAVX1103-I SQL Server information has been updated
17. Update the dictionary map files at the remote site.
To update the dictionary map files, execute the drmsqldisplay command on the database
server at the remote site.
PROMPT> drmsqldisplay -refresh
KAVX0023-I Dictionary map file was updated.
Operation for SQL Server databases354