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

1. Back up the user database.
On the database server (active server), execute the drmsqlbackup command with the -target
or -f option specified.
To execute the drmsqlbackup command with the -target option specified:
PROMPT> drmsqlbackup instance-name -target user-database-name
To execute the drmsqlbackup command with the -f option specified:
PROMPT> drmsqlbackup instance-name -f target-definition-file-name
2. Back up the user database transaction logs.
On the database server (active server), execute the drmsqllogbackup command.
PROMPT> drmsqllogbackup instance-name
3. Use a tool such as SQL Server Management Studio to delete the AlwaysOn availability group
configuration for the database server (active server).
4. Restore the user database.
On the database server (active server), execute the drmsqlrestore command.
PROMPT> drmsqlrestore backup-ID -resync -target user-database-name
5. Recover the SQL Server database.
On the database server (active server), execute the drmsqlrecover or drmsqlrecovertool
command.
To execute the drmsqlrecover command for recovery:
PROMPT> drmsqlrecover instance-name
To execute the drmsqlrecovertool command for recovery:
PROMPT> drmsqlrecovertool instance-name
6. Use a tool such as SQL Server Management Studio to create the AlwaysOn availability group
configuration for the database server (active server).
Restoring a user database to the standby server from the active server
To restore a user database to the standby server from the active server:
Operation for SQL Server databases396