Post reply

Windows Cluster Service and SQL 2005 multiple instances

  • September 23, 2009 at 8:37 am

    #211397

    Hey y'all! Thanks in advance for any advice to my dilemma.

    I have two separate DB applications that require their own SQL 2005 instance. I've set up a MSCS with an IP, Name, Quorum, Local Quorum and a MSDTC Resource.

    I would like to set up two separate SQL Instances (groups) that that use the same MSCS. Are there any issues/concerns with this configuration?

    Also, I'd like to use a shared SQL Backup partition and plan to assign it to the MSCS so it is available to both SQL instances.

    Thanks in advance!

    Cheers,

  • September 23, 2009 at 9:01 am

    #1057573

    i think you could do an Active-Active cluster ... where both instances of SQL Server are Active and each runs on its different node of the the cluster. Shared Drive available to both SQL instances is something I have not explored.

    -------------------------------------------------
    -Amit
    Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

  • September 23, 2009 at 10:50 am

    #1057648

    are you suggesting that I set up two separate clusters?

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

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