Backing up the databases, Restoring the databases, Restarting operations – HP XP Racks User Manual

Page 415

Advertising
background image

Figure 26 Configuration of backup server for the publisher/distributor server (detail)

Backing up the databases

The publication database needs to be backed up at the same time as the distribution database. From
the Select Target window of the Create Replica Wizard, select both the publication and distribution
databases.

Backing up the publication database transaction log

Use Management Studio to back up the transaction log.

Restoring the databases

To restore a database, the following conditions must be satisfied:

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 subscription agent.

When preparations are complete, use the Restore Replica Wizard to restore the databases.

Restarting operations

Before resuming operation, you must perform startup operations on the server associated with the
subscription format:

User Guide

415

Advertising