sql server replication: We are running SQL Server 2000 and whenever we reboot a
server that is replicating we have to go restart the
agents. Is there a way to set SQL server to

Hi Mike,

I am not sure what you mean by "restart all the agents". In replication,
each agent has their own job schedule. When the SQL Server Agent starts,
not all agents need to run immediately. Please provide me your exactly
purpose for restarting all the agents.

Before we reboot a server, we need to set SQL Server Service and SQL Server
Agent Service to start automatically. In the Service Manager, check the
"Auto-start service when OS starts" option with SQL Server and SQL Server
Agent.

There are four schedule types with replication agent:
1. Start automatically when SQL Server Agent starts
2. Start whenever the CPU(s) become idle.
3. One time
4. Recurring

You can perform the following steps to choose one of them for the agents.
Right click Agent item'Select Agent Properties'Select Schedules Tab'Click
Edit button'Select the schedule types which you want in the Edit Job
Schedule dialog.

For more information regarding this issue, please refer to the following
article on SQL Server Books Online.
Topic: "Job Schedule Properties"

Please let me know if this solves your problem or if you would like further
assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Michael,

We are pushing data from server A to server B. When server B is rebooted we have to go into

Hi Mike,

Thanks for your feedback. I want to restate the problem first. When the
Server B is rebooting, there are changes on the publisher (Server A). You
want to start merge agent automatically to synchronize these changes from
Server A to Server B after the reboot of Server B. If I have misunderstood,
please feel free to let me know.

How long does the reboot of Server B need? Based on my experience, When the
Server B is rebooting, merge agent cannot connect to Server B so that the
changes on publisher (Server A) cannot be synchronized to Server B
immediately. Merge agent will continuously try to connect to Server B.

We can try to set some options of the Run agent Job in Merge agent to
increase the retry time so that we do not need to click Start Synchronizing
manually after the reboot of Server B. The options are Retry attempts and
Retry interval.

You can try to perform the following steps to set these options.
Right click Merge agent option'Click Steps tab'Double click Run agent
job'Choose Advanced tab'Set the Retry attempts and Retry interval options.

We can let the merge agent retry time meet the reboot time of Server B so
that we do not need to click Start Synchronizing manually.

Please let me know if this solves your problem or if you would like further
assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.