April 8, 2008 at 12:01 am
Hi,
When I check the publication in replication monitor it shows (a small red cross mark) on the publication.And when I right click it says connect to distributor. I guess that the connection is lost and I clicked on connect to distributor but it works for a few mins and after that the icon changes to same and I cannot see any subscriptions in the right unless i click on connect to distributor. Can anyone helpme its very urgent
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
April 14, 2008 at 11:02 am
you should investigate what the problem is
LogReader [reads from pub db and writes to distribution db]
Distribution Agent (DA) [reads from distribution and applies to sub db]
from what you have said, I am guessing that the DA is delivering data and/or creating PK and indexes at sub, but after working [say for 10 mins] the DA raises that "red flag" but it keeps on working (so will eventually clear)
as DBA you should define yourself as an Operator and check all the boxes for warnings+alerts
- then you get notified whenever repl is having a bad time
if you experience lotsa DA complaining "no response from sub", then you should
encourage users to have shorter transactions
review indexes at the sub(s)
check network
etc
and if appropriate you can change the profile to give longer before complaining
HTH
Dick
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply