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 |
|
rajesha
Starting Member
36 Posts |
 Posted - 2002-06-22 : 06:16:34
|
| i want to know one thing.where should i schedule (snapshot agent or distribution agent)in order to avoid network traffic on peak times.i want to schedule in off peak time.here publisher and distributor is in the same server.can anybody tell me about it.should i have to schedule in both? |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-22 : 15:47:37
|
| If you are doing transactional replication and don't have anymore new subscribers, you can disable the snapshot agent, as there's no need for it to run. You can schedule the distribution agent, from the 'replication monitor' on the distributor. Just right click on the agent, go to properties. I don't have Enterprise Manger in front of me to walk you through.Let your logreader agent run continuously or else you'll have problems with transaction log growth.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
which agent should i schedule -snapshot or distrib