SQL Server Performance Forum – Threads Archive
auto switch for updateable subscriptionsI have the option set immediate updating with queued updating as a failover: Is there a way to automate (maybe as a stored procedure or something) switching between the two updating methods when the newtork connection fails (immediate updating to queued updating) and visa versa (queued updating to immediate updating when connection is back)?
May look at sp_setreplfailovermode:
Allows you to set the failover operation mode for subscriptions enabled for immediate updating with queued updating as failover. This stored procedure is executed at the Subscriber on the subscription database.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Thanks – is there a way that can detect if the network connection open or not? If not then obviously the transactional replication when the replication failover mode is set to immediate updating will not work – is there some way to pick this up and then maybe fire the trigger to set the failover mode to queued updating? CE