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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Merge Agent Connectivity

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-15 : 09:24:34
John writes "Hi guys,

I have a rather urgent question.

I'm running SQl Server 7.0 (SP2) on two NT Server 4.0 (SP5) servers at different locations. I have merge replication set up between the servers (one DB). The distributor is on Server1 and the subscriber is on Server2. Replication was set up from Server1 as a push. The merge agent runs once per day early in the morning.

I have to shut down Server2 (subscriber) for about 10 days during an office renovation, but Server1 (distributor) must remain up to accept data. How long will merge agent continue trying to contact the subscriber? Indefinitely, so I can then just bring Server2 two back up and run the agent, syncing the DBs? Or do I have to reconfigure the agent? Or does it stop trying after a set time (I accepted all the defaults when setting up replication)?

Thanks in advance for your help.

John"
   

- Advertisement -