How to configure a publication to allow copying of subscription databases (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure a publication to allow copying of subscription databases (Enterprise Manager)

  1. Create the publication using the Create Publication Wizard.

  2. In SQL Server Enterprise Manager, expand the Replication and Publication directories, and then right-click the publication that you want to enable for new subscriptions.

  3. For snapshot replication and transactional replication, click the Subscription Options tab in the Publication Properties, select Use a Distribution Agent that is independent of other publications from this database, and then select Snapshot files are always available to immediately initialize new subscriptions. You do not need to do anything for this step if you are using merge replication.

  4. Select Allow new subscriptions to be created by attaching a copy of a subscription database.