Post reply

Best Way to Implement MultiServer Admininstration Redundancy?

  • July 9, 2009 at 10:28 am

    #208086

    Hello,

    I'm looking into utilizing MultiServer Admininstration on our sql 2005 landscape. It consists 3 or 4 servers which comprise a dozen or so instances. Small fries to many I know, but keeping up bug fixes and improvements to the maintenance related tasks is becoming a chore.

    Multi-server admin looks pretty good, but does it scale to the redundancy methods such as mirroring etc. It seems all the eggs are in one basket now and if it goes down it will be pain to limp along until it can come back up.

    Could you restore the master and msdb databases from the master onto another server (of the same sql 2005 build)? I'm open to suggestions, and if you have any pointers to good articles on managing these types of issues in disaster recover/high availability they'd be greatly appreciated.

    Thanks,

    Scott

  • July 9, 2009 at 12:41 pm

    #1022609

    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

    #1022623

    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

    #1023757

    Multi server admin normally helps you with the jobs mainly when you want to configure similar jobs on many servers. you can chck out

    http://books.google.co.in/books?id=GQOC5WUPPbIC&pg=PA222&lpg=PA222&dq=how+to+run+multi+server+sql+server+job+from+one+instance&source=web&ots=h5XtId9ux2&sig=XQ3eEdltgpCYQlfKDoBR1NtsMrA&hl=en&sa=X&oi=book_result&resnum=2&ct=result#PPA222,M1

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

Viewing 4 posts - 1 through 3 (of 3 total)

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