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.
| Author |
Topic |
|
donpolix
Yak Posting Veteran
97 Posts |
 Posted - 2008-02-15 : 15:19:58
|
| Hi guys, anyone has multiserver administration setup for your backup jobs? It's been tedious creating maintenance plans and jobs for each instance, and I am looking into this feature hoping for some convenience and to save time managing and reporting job failures. Can anyone share their experience? pros/cons..appreciate any feedback. Thanks.Donn Policarpio |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:37:22
|
| You can create jobs in that but not maintenance plans. |
 |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2008-02-16 : 18:03:58
|
| Thanks rmiao. A script for the backup jobs in the master server would work better then. I wonder what the common problems are using multiserver setup.Donn Policarpio |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 19:36:18
|
| You still need create job for each server, the difference is that you do it from master server only instead of every server. |
|
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2008-02-17 : 12:09:09
|
| I got that part where the target servers get a copy of the jobs. Seems you always got the right answer,..appreciate it.If you don't wanna buy third party software to manage your backups, would you recommend multiserver administration for ease of maintenance of backup jobs if dealing with over a hundred instances?Donn Policarpio |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-17 : 16:29:25
|
| You may need a dedicated server for that in this case. |
|
|
|
|
|
|
Multiserver administration