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.