Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sassaidi
Starting Member
7 Posts |
 Posted - 2003-10-28 : 22:24:23
|
Hi,I have setup replication where one box has the publisher and one is the distributer and the subscriber. There are 2 databases being replicated with transactional replication.The problem I have is that both of the Log Reader agents fail (about 15 times in a day). When I start the agents manually, everything resumes to normal and all transactions are applied. The only msg I get when one of the agents fails is:"The step did not generate any output. The step failed.".I have enabled the agent to create an output file and log everything (-outputverboselevel 2) and all I get on the distributor/subscriber box is the following:Disconnecting from Publisher 'SERVERPUB'"where SERVERPUB in the publisher server on the same DMZ.Your help will be very appreciated Sas  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-29 : 12:13:57
|
| Are you having any network problems between the two servers? Are there any errors in the SQL Server Error Log on either server that give more information?Tara |
 |
|
|
KingSexy182
Starting Member
7 Posts |
Posted - 2003-10-29 : 17:37:53
|
| Also I think it could be timing out when trying to start the agent again?try change the timeout property in the agent profile to a longer period. say 300 seconds (5 minutes) |
|
|
|
|
|
|
Log Reader agent randomly fails