SQL Server Performance

How to install second instance in Act/Pas CLuster

Discussion in 'SQL Server 2005 Clustering' started by victorrodrigues, May 29, 2007.

  1. victorrodrigues New Member

    I have just setup MSSQL 2005 in an Active/Passive Cluster mode running on Windows 2003 server. Now i have a request to setup a second Named Instance on the same cluster. I am looking for a document that would outline the procedure which will include the prerequisites.
    The thing that I am worried about is that i read somewhere that each instance will need its own shared disks. If this is true , I will need to rearrange my Storage on my SAN which is cumbersome. I am hoping its not soo complicated. I hope I can use the same shared disks.
    I also read about having to setup the Alias using Network Configurator ( SQL 2000) else the installation will fail.
    To clarify all these doubts and to setup up the 2nd instance correctly, I would be glad if anyone here could direct me to where I could find good documentation to that effect.

    Thanks
    Victor
  2. MohammedU New Member

    You don't need to create the alias like in sql server 2000...
    You can do the regular installation...
    Do not use the same disks...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. victorrodrigues New Member

    Hi Mohammad,
    thank you for the prompt reply,
    what do u mean dont use the same disks...I am guessing I will need only the Data Disk right, and that I can use the same Quorom ,Log and MSDTC disks? why cant i use the same disks ?
    I mean. if i want the instances to move together across my nodes, why not ?(i am in active/passive cluster mode)
    unfortunately i am a newbie with MS clustering . so am learning right now.I have experience with some UX clustering and
    any hints u provide will speed up the process
    an installation doc would be perfect..

    thanks

    Victor
  4. satya Moderator

    http://www.sql-server-performance.com/bm_cluster_server_2003_02.asp fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page