May 24, 2005 at 7:30 am
We have a simple replication scenario with a database and a client running the personal edition of SQL Server 2000. The server is running SQL Server 2000. We are running merge replication pushing the data out to the PC. The problem we are experiencing is the PC is not always on. This creates an error in for the replication service to that client, as expected. However, during our testing we noted that the service would automatically resume when the connection was restored. My question is there a way to have the server/publisher resume replication automatically?
Thanks for your help in advance.
May 24, 2005 at 10:49 am
If you run the merge agent continuously (parameter -continous for the agent) you could add another jobstep which waits a couple of minutes and resumes execution at job step 1 ("endless loop" model)
Another option is to schedule the merge agent so it will automatically pick up/ send changes the next time it runs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply