Post reply

Looking for advice on a clustered VM setup of sql server

  • April 19, 2012 at 5:31 pm

    #392071

    Hi everyone.

    My company will be setting up a clustered instance of SQL server 2k8 r2 on vm's and I wanted to know if anyone had recommendations for a book that could help.

    Normally I lean on the dev side of SQL server but I will be asked to provide input on this project and I'd like to educate myself beforehand.

    We're a financial institution and as such up time is extremely important.

    I'd prefer a book on the subject but I'm OK with material online if it's good.

    Thanks in advance.

    Mark

  • April 19, 2012 at 10:33 pm

    #1476406

    not sure about books...

    but

    http://www.ipsure.com/blog/2010/clustering-ms-sql-server-2008-r2-on-vmware-virtual-windows-server-2008-r2-1/

    http://clusterwhere.wordpress.com/2011/03/07/setup-microsoft-sql-server-2008-r2-failover-cluster-in-vmware-workstation-7/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • April 19, 2012 at 10:53 pm

    #1476414

    Check out this link as well.

    Creating a 2 Node SQL Server 2008 Virtual Cluster[/url]

    M&M

  • April 20, 2012 at 12:50 am

    #1476436

    If you are planning for 2 node failover cluster..then few things to consider

    1) Storage and how are you planing to store data , log , backup temp files

    2) IP address, you need 2 public ips, 2 private ips and 3 virtual ips

    3) You should have create computer objects in Active directory

    4) Plan the same domain account for both the nodes

    "More Green More Oxygen !! Plant a tree today"

  • April 20, 2012 at 8:35 pm

    #1476992

    All,

    I'll check out the links. Thanks for the information!

    Regards,

    Mark

  • April 21, 2012 at 2:42 am

    #1477021

    meckeard (4/19/2012)

    Hi everyone.

    My company will be setting up a clustered instance of SQL server 2k8 r2 on vm's and I wanted to know if anyone had recommendations for a book that could help.

    ...................

    but I'm OK with material online if it's good.

    Thanks in advance.

    Mark

    I was going to link my popular article on this site but Mohammed beat me to it. If you get stuck with the article post back in the article discussion thread

    😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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