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

• Restore only the system databases
Specify the backup ID used when the databases, including the system databases, were backed
up, and execute the drmsqlrestore command on the publisher/distributor server or the subscriber
server.
PROMPT> drmsqlrestore 0000000005 -resync -target master,model,msdb
PROMPT>
• Restore the subscription database
On the subscriber server, execute the drmsqlrestore command.
PROMPT> drmsqlrestore 0000000002 -resync -target SubUserDB1
PROMPT>
Perform database recovery
Use the drmsqlrecover command or the drmsqlrecovertool command to perform a recovery
(roll forward) by using the normal procedure.
Prepare to restart operations
The following must be prepared in order to restart SQL Server replication operations:
The server that performs these operations will depend on the subscription format, as follows:
Push subscription: Publisher/distributor server
Pull subscription: Subscriber server
1. Start the log reader agent.
2. Start the agent associated with subscription.
Synchronous subscription is started.
3. Perform subscription re-initialization or deletion and re-creation.
Setting and checking the 'sync with backup' option
When the SQL Server replication function is used, the 'sync with backup' option must be set for
the publication database and the distribution database.
When backup is performed on the publication database transaction logs with the 'sync with
backup' option set, the backup is forwarded to the distribution database. Also, no publication
database logs will be dropped until all transactions are forwarded to the distribution database.
Application Agent CLI User Guide 393