December 29, 2009 at 1:10 pm
Basic setup:
production server with active / passive clustering
prod DB is transaction replicated to a third server (pull subscription)
Current maintenance restart / reboot sequence (which is basically just rebooting the server itself with no real attention to replication or SQL Server) is causing replication errors and 2 am calls for me. Not good.
This is in an official maintenance window, so no access / stale data on reports server for a limited time is acceptable. Maintaining failover would be good but not an absolute.
I have ideas, but would love to hear some of your hands-on experience with this.
Thanks, everyone.
December 29, 2009 at 2:01 pm
What errors are you getting?
December 29, 2009 at 2:13 pm
The one I dealt with yesterday / last night was the fact that replication thought it was running, but no data was showing up on the subscriber since the reboot.
Log reader agent errors during publisher downtime / switch"
no replicated transactions are available
the process could not execute 'sp_replcmds' on 'production server'
On the distribution agent:
The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.
in distribution, seeing multiple messages of PK violations.
maintenance included index reorg / rebuild
December 30, 2009 at 7:24 am
Thanks Pam for the response. What are you distribution and log reader agent profile parameters?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply