HP XP Racks - Manual (Page 414)

When the SQL Server replication function is used, the following requirements must be satisfied:
• You must use the transaction replication type.
• The name of the distribution database must be
distribution
, and only one distribution database
can be created.
• The subscription database must be restored separately from the system database (master, model,
msdb), so the subscription database must be configured in a different volume than the system
database.
• The Sync with backup option must be set for both the publication database and the distribution
database. For details about how to set and view this option, see SQL Server Books Online.
SQL Server system configuration
The example is based on the system configuration shown in the figure below.
Figure 25 Configuration for using the SQL Server Replication function
Requirements for the publication and distribution databases
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.
Managing application replicas 414