beautypg.com

HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 389

background image

Figure 109 Configuration for using the SQL Server replication function

Requirements for the publication database and the distribution database

The publication database and the distribution database used in the processing of a single replication
must be allocated to satisfy the following requirements:

Because backups of these two databases must be made at the same time, they must be allocated
to the same SQL Server instance.

Because these two databases must be restored separately from the system databases (master,
model, and msdb), they must be allocated to a different volume from the system databases.

Application Agent CLI User Guide

389