How to enable immediate updating with queued updating as a failover (Enterprise Manager)

How to Install SQL Server 2000

How To

How to enable immediate updating with queued updating as a failover (Enterprise Manager)

  1. In the Create Publication Wizard, on the Welcome page, select Show advanced options in this wizard.

  2. Select either Snapshot publication or Transactional publication, and then on the Updatable Subscriptions page, select both Immediate updating and Queued updating.

  3. When you create a subscription using either the Pull Subscription Wizard or Push Subscription Wizard, on the Updatable Subscriptions page, select Immediate updating with queued updating as a standby in case of failure.