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 |
|
cottage125
Starting Member
32 Posts |
 Posted - 2008-05-19 : 14:47:08
|
| I am doing Transactional ReplicationI 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. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-19 : 14:55:27
|
| It's because you have lots of transaction being replicated. Try increasing inactivity threshold in replication monitor. |
 |
|
|
cottage125
Starting Member
32 Posts |
Posted - 2008-05-19 : 15:02:53
|
| where is tht..i could not find anywhere |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-19 : 15:38:59
|
| In replication monitor- refresh and settings |
|
|
|
cottage125
Starting Member
32 Posts |
Posted - 2008-05-19 : 15:43:40
|
| sir in Sql 2005 i am not able to find it. Can u please help me in this. i will really appreciate it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-19 : 23:15:58
|
| Does disk that holds snapshot have enough free space? |
|
|
|
cottage125
Starting Member
32 Posts |
Posted - 2008-05-20 : 12:57:34
|
| ya it has enough space.. i checked it...i think indexes got messed up..it might be reason for this error? |
|
|
|
|
|
|
replication error