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

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 359.
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
- - - - SI01,sql01 - CL1-A
1 60 0 60 S 116
- - - - TC01,sql01 - CL1-A
1 32 0 32 S 600
- - - - TC01,sql01 TC01,sql01#0
- - - 0 60 C 600
T UserDB1 TRANSACT Z:\UserDB1_Log.LDF - - CL1-A
1 32 - 32 P 116
- - - - SI01,sql01 - CL1-A
1 60 0 60 S 116
- - - - TC01,sql01 - CL1-A
1 32 0 32 S 600
- - - - TC01,sql01 TC01,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 TC01 -d sql01
PROMPT> pairsplit -g TC01 -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.
Application Agent CLI User Guide 357