Requirements for the subscription database, Example, Back up the databases – HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 390
Figure 110 Configuration of backup server for the publisher/distributor server
Requirements for the subscription database
Because the subscription database must be restored separately from the system databases (master,
model, and msdb), it must be allocated to a different volume from the system databases.
Example
The example uses the following database names:
Publication database:
PubUserDB1
Subscription database:
SubUserDB1
Distribution database:
distribution
Back up the databases
•
Back up the publication database
Additional explanation
When the publication database is backed up, the distribution database must be backed up
at the same time.
On the publisher/distributor server, execute the
drmsqlbackup
command with the publication
database and the distribution database specified in the
-target
option or
-f
option.
Operation for SQL Server databases
390