HP XP Command View Advanced Edition Software - Manual (Page 393)

PROMPT> drmsqlbackup instA -target PubUserDB1,distribution
PROMPT>
• Back up the subscription database
Execute the
drmsqlbackup command on the subscriber server.
PROMPT> drmsqlbackup instC
PROMPT>
• Back up the databases, including the system databases
Execute the
drmsqlbackup command with the -system option specified in the publisher/dis-
tributor server or the subscriber server.
PROMPT> drmsqlbackup instA -system
PROMPT>
Back up the transaction logs of the publication database
Execute the drmsqllogbackup command on the publisher/distributor server.
PROMPT> drmsqllogbackup instA
PROMPT>
Prepare for database restoration
To restore a database, the following conditions must be satisfied beforehand:
• When the publication database is restored, the distribution database must be restored at the same
time.
• When the publication database is restored, this database must be online or have been deleted.
• When the system database is restored, the publication database must be online.
The following preparations are required to restore the databases. However, if only the subscription
database is to be restored, perform only step 2 (subscription synchronous stop).
1. Stop the log reader agent.
2. Stop the agent associated with subscription.
A subscription synchronous stop is performed. If the agent does not stop, the detach processing
will fail and an error message will be output.
Application Agent CLI User Guide 393