Multiserver Administration Architecture

  • I need to be able to run the same backup procedures on several SQL Servers. I understand that it is possible to define a 'master' and its associated 'target' servers so that you can implement a job on the 'master' server and have the 'target' servers poll it to access the job info using the Multiserver Administration features.

    My question is... what happens if the master server goes down? Are local copies of the job kept on the target servers or will the whole backup strategy fall in a heap?

    Thanks.

  • If the master server goes down, all the jobs in the target server will remain executing according to the original schedulle as if the master server still exists.

    But the history of the executions won't replicate.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply