| Event Id | 21189 |
| Source | MSSQLServer |
| Description | The queue for this subscription with queue_id = %s is not empty. Run the Queue Reader Agent to make sure the queue is empty before setting mode from [queued] to [immediate]. |
| Event Information | CAUSE: For subscriptions enabled for Immediate updating with queued updating as failover, you cannot issue sp_setreplfailovermode to change the failover operation mode from queued updating to immediate updating if there are unreplicated transactions in the queue. RESOLUTION: If users are active on the Subscriber, you will need to prevent them from making further updates that will add transactions to the queue. Execute the Queue Reader Agent to move all unreplicated transactions to the Publisher, and then reissue sp_setreplfailovermode. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 21189 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.