Prepare for database restoration, 391 prepare for database restoration – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 391

Advertising
background image

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

391

Advertising