Attachable Subscription Databases

Attachable Subscription Databases

SQL Server 2000

The attachable subscription databases feature allows you to transfer a database with published data and subscriptions from one Subscriber to another. After the database is attached to the new Subscriber, the database at the new Subscriber will automatically receive its own pull subscriptions to the publications at those Publishers.

Attachable subscription databases requires the following steps:

  1. Configuring a publication to allow copying.

  2. Copying the subscription database.

  3. Transferring and attaching the subscription database to a new Subscriber.

Subscription databases copied and attached to other Subscribers can contain multiple pull subscriptions for multiple publications using snapshot replication, transactional replication, or merge replication. Attachable Subscription databases are not compatible with heterogeneous databases or instances of Microsoft® SQL Server™ version 6.5. This feature is not available with push subscriptions.

© 2016 Microsoft