Viewing 5 posts - 1 through 5 (of 5 total)
Tried that already... no such luck... tonight I'll try rebooting the publisher server - poor thing's been up for a couple of months 😉
January 22, 2009 at 9:57 am
@noeld: thanks for your suggestions;
- I had already stopped/started the agent - multiple times 😉
- The appropriate profile is checked for the agent in use
- Using a...
January 21, 2009 at 1:56 pm
Additionally, I have specified following definition of step 2 "Run agent." in the Log Reader Agent:
[font="Courier New"]-Publisher [SRVDB01\SQL2005] -PublisherDB ["DATABASE"] -Distributor [SRVDB01\SQL2005] -DistributorSecurityMode 1 -ReadBatchSize 50 -Continuous[/font]
... which doesn't seem...
January 20, 2009 at 8:34 am
Im quite confused meanwhile: please consider following statement retrieving all parameters from agent profiles which contain the "ReadBatchSize" parameter:
[font="Courier New"]SELECT pr.profile_name, pr.agent_type, pr.type, pa.*
FROM MSagent_profiles pr
JOIN MSagent_parameters pa ON...
January 20, 2009 at 6:35 am
Thanks for your prompt answer! I am currently trying (from default values QueryTimeout=1800; ReadBatchSize=500) QueryTimeout=65534 (max. allowed); ReadBatchSize=50... no avail... in the log file viewer I see the following entry:...
January 20, 2009 at 3:43 am
Viewing 5 posts - 1 through 5 (of 5 total)