I installed a new sql 2005 server and set 4 publications with subscription.
The replication is working but looks slow....It means when I change a value into a table the transaction take more than 30 secondes before it came into the synchronisation status monitor.
I saw that for each subscription my logreader agent could not start ...I have the following message.
MessageExecuted as user: 280db02\280db02sql. The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more information.
Message-XCMDLINE 0ÃÂ ÃÂ ÃÂ -XCancelEventHandle 00000000000007B4ÃÂ ÃÂ ÃÂ -XParentProcessHandle 00000000000003C82007-04-20 09:54:32.109 Parameter values obtained from agent profile:ÃÂ ÃÂ ÃÂ -pollinginterval 5000ÃÂ ÃÂ ÃÂ -historyverboselevel 1ÃÂ ÃÂ ÃÂ -logintimeout 15ÃÂ ÃÂ ÃÂ -querytimeout 1800ÃÂ ÃÂ ÃÂ -readbatchsize 500ÃÂ ÃÂ ÃÂ -readbatchsize 5000002007-04-20 09:54:32.109 Status: 4096, code: 20024, text: 'Initializing'.2007-04-20 09:54:32.109 The agent is running. Use Replication Monitor to view the details of this agent session.2007-04-20 09:54:32.125 Status: 16384, code: 20007, text: 'No replicated transactions are available.'.2007-04-20 09:55:37.125 Status: 16384, code: 20007, text: 'No replicated transactions are available.'.2007-04-20 09:55:37.125 Status: 0, code: 22037, text: 'The last step did not log any message!'.20
View Complete Post