HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

18. Create a template catalog at the remote site.
To create a template catalog, execute the drmsqlbackup command on the database server at
the remote site. The drmsqlbackup command does not perform backup when it is used to create
a template catalog.
PROMPT> drmsqlbackup default -template
KAVX0001-I The drmsqlbackup command will now start.
KAVX1017-I SQL Server information is being collected now.
KAVX0085-I Now making backup information...
KAVX0086-I The backup information has been assigned as follows:
Backup ID = 0000000001
KAVX0002-I The drmsqlbackup command will now end.
If you plan to perform backup at the local site by using the drmsqlbackup command with the
-target or -f option specified, create a template catalog according to the option setting.
PROMPT> drmsqlbackup default -target UserDB1 -template
KAVX0001-I The drmsqlbackup command will now start.
KAVX1017-I SQL Server information is being collected now.
KAVX0085-I Now making backup information...
KAVX0086-I The backup information has been assigned as follows:
Backup ID = 0000000002
KAVX0002-I The drmsqlbackup command will now end.
You can also delete the template catalog:
PROMPT> drmappcat 0000000001 -delete
KAVX0424-I The backup information corresponding to the specified backup ID has been deleted.
Backup ID = 0000000001
19. Detach the SQL Server database.
Use SQL Server Enterprise Manager or an equivalent tool to detach the user database at the
remote site you want to back up. If the backup targets include the system databases (master,
model, and msdb), stop the SQL Server service at the remote site and unmount the Continuous
Access Software pair volume.
20. Export the template catalog at the remote site.
To export the template catalog, execute the drmdbexport command on the database server at
the remote site. Save the exported catalog file in a file for storage because it will be required for
restoration.
PROMPT> drmdbexport 0000000002 -f c:\templateCat.drm
KAVX0001-I The drmdbexport command will now start.
KAVX0002-I The drmdbexport command will now end.
21. To change the secondary volume at the local site to the primary volume, perform takeover.
To perform takeover, execute the RAID Manager command horctakeover at the local site.
PROMPT> pairresync -g TC01 -d sql01
PROMPT> horctakeover -g TC01 -d sql01
22. Mount the Continuous Access Software pair volume at the local site and start the SQL Server
service.
Operation for SQL Server databases356