May 19, 2008 at 12:42 pm
I am doing Transactional Replication
I am bring 8 tables from one server to another. ALL the tables are working fine means its creating snapshot in snapshot folder except one table which brings 12 millions records.
I am getting Error in Snapshot Agent : the Agent Is in Suspect Mode, No response within last 10 minutes.
Any suggestion is greatly apreciate.
Thank you for help.
May 19, 2008 at 12:52 pm
thats just the standard message that comes up when it means its waiting for the snapshot to be applied. If it times out ( i think the default is 10 minutes) then change the properties of the agent to have a longer timeout period.
You may also want to check for any locking that may be stopping the snapshot from being applied.
May 19, 2008 at 1:05 pm
hello Can you explin tht steps in advance as i doing transaction replication from sql 2000 to sql 2005. i could not find where to incrase the default time
May 20, 2008 at 1:43 am
If you go to your replication monitor, find the replication job that it timing out, right click and go to "agent profile". You will probably have the default profile selected. Click new to create a new profile and change the -QueryTimeout parameter to something longer than it is, you can always change it back or make it longer. Select that new profile to be used. stop and start the replication job.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply