April 28, 2008 at 8:42 am
We have a Publisher and two subscribers set up as Transactional Updateable - Immediate with Queued. We plan to take down the publisher for three hours for maintennace whilst the subscribers will stay up.
My question. Do I have to manually change the Subscription from immediate to queued by running "sp_setreplfailovermode" or in EM by setting the the subscription at the subscriber to Queued?
or does SQL Server handle this all on its own and the queuing will be automatic?
Thanks in advance
April 28, 2008 at 9:12 am
If the publisher is down, there should be no queuing. It has to do the queuing when the subscribers are down.
If should pick back up automatically. Are these pull or push subscriptions?
April 28, 2008 at 9:28 am
Hi Steve, thank for the quick response. These are push subscriptions.
From what you have said, does this mean that updates to the subscribers will be queued by default if the Publisher is down?
What confused me is reading about "sp_setreplfailovermode" and various discussions saying that although the Publication is set up as "Immediate with Queued updating" if the Publisher is down then I have to manually change the Update Method to Queued as the default will always be Immediate.
April 29, 2008 at 7:43 am
I have just tested this and you do have to change the subscription manully to 'Queued' otherwise any updates to the subscribers dail with "Server not exists". You would expect that SQL Server automatically reverts to queued if the Publisher fails but it appears thats not the case
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply