| Event Id | 21185 |
| Source | MSSQLServer |
| Description | The subscription is not initialized or not created for failover mode operations. |
| Event Information | CAUSE: sp_setreplfailovermode is used in snapshot replication or transactional replication for which subscriptions are enabled for "Immediate updating with queued updating as a standby in case of failure." sp_setreplfailovermode is used to switch to queued updating mode when the publisher is not available to the Subscriber or to switch back to immediate updating mode after the Publisher becomes available again. If you execute sp_setreplfailovermode for a subscription that is not enabled for "Immediate updating with queued updating as a standby in case of failure," you will receive the above error. RESOLUTION: To fail over between immediate updating and queued updating, the publication must be enabled for both immediate updating and queued updating, and the subscription must be enabled for "Immediate updating with queued updating as a standby in case of failure." For instructions on how to enable a publication and subscription for "Immediate updating with queued updating as a standby in case of failure," see "How to enable immediate updating with queued updating as a failover (Enterprise Manager)" and "Updatable Subscriptions, Subscription Wizards" in Books Online. To check which mode this type of subscription is currently set to, use the stored procedure sp_helpreplfailovermode. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 21185 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.