July 9, 2009 at 12:41 pm
I'm not quite sure what you mean by "multi server admin". DO you mean the method in which you log on to each server and perform admin duties like with SSMC? Or do you mean such things as redundancy/backups/log shipping/mirroring?
Backing up master and msdb is always good, but my disaster recovery plan would not depend upon restoring to the exact same build of software. Your recovery plan should be flexible enough so that you could restore everything even to SQL Server 2008 if need be.
The probability of survival is inversely proportional to the angle of arrival.
July 9, 2009 at 1:08 pm
I'm referring to the capability of using one server as a master to execute jobs on target servers.
There's SSIS tasks that can copy jobs, but I'm not sure how it'll behave with a master server. Going to find out...
Thanks,
Scott
July 13, 2009 at 3:51 am
Multi server admin normally helps you with the jobs mainly when you want to configure similar jobs on many servers. you can chck out
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply