Hello Guys,
I have set up a transactional replication with 2pc's.
One server is the publisher & the distributor, and the other one is the
subscriber.
Everything is fine, but the replication stops when my partner shut down
the subscriber pc, now I have to restart the replication, but I don't
know how to do it because I tried to restart the agents and it didn't
work.
Which agent is supossed to be restarted?.
Thanks,
*** Sent via Developersdex http://www.codecomments.com ***
Javier,
you'll need to restart the distribution agent. If it generates an error,
this might be because of the distribution retention period being exceeded.
Please can you post up any errors you see and we'll work it out.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Wednesday, March 21, 2012
Replication Problem, Please Urgent Help!
Labels:
2pcs,
database,
distributor,
guys,
microsoft,
mysql,
oracle,
publisher,
replication,
server,
sql,
transactional,
urgent
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment