May 19, 2008 at 10:08 am
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.
Pls help me fast
May 20, 2008 at 6:35 am
Creating a snapshot of 12 million rows can take quite long and like in your case can result in a timeout. You can change the profile of the snapshot agent and increase the timeout value. That should solve your problem.
[font="Verdana"]Markus Bohse[/font]
May 23, 2008 at 9:55 am
Thanx for ur suggestion but still its give me same error i increased the query time out ..but still same problem. is there another way to do it?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply