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 |
|
sql2k8
Starting Member
3 Posts |
 Posted - 2008-04-27 : 16:48:15
|
| hi,the distribution agent says that the process is running and waiting for response from the server .i have replication set up for different locations.only one location bothers me.it runs for hours and it will not get complete for quite a few days.once it is done i am missing the data for few days.can you please tell to me how to make the distribution agent run faster with out much delays.thank you, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-27 : 17:02:25
|
| What is network bandwidth for that location? Did you set Query timeout ? Did you check job history? |
 |
|
|
|
|
|
distribution agent at the publisher