Post reply

SQL Disk Error

  • July 15, 2013 at 12:00 am

    #275268

    Dear Gurus,

    I am getting attached error of disk when installing SECOND INSTANCE of SQL 2008 R2 please help .

    http://tinypic.com/view.php?pic=2nuk85z&s=5

    http://tinypic.com/r/14crv5u/5

    http://tinypic.com/r/t057jr/5

    Your kind help is needed.

    Thanks

    Malik Adeel Imtiaz

  • July 15, 2013 at 3:11 am

    #1632367

    I can see no error messages in any of those images - Can you post the exact text of the message you are seeing please?

    I would suggest you post it as text - not links to images - many people will not open those at all.

    Mike John

  • July 15, 2013 at 3:17 am

    #1632369

    I notice a warning about the "cluster validation". Please run the cluster validation check from Windows and correct all reported problems.

    I notice the message stating "clustered disk unavailable". Are the disk(s) assigned to the cluster group? Are you executing the first install on the active node? If you are installing a second instance on the cluster you need to have another cluster group. You can't use the same cluster group from a previous SQL instance.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • July 15, 2013 at 3:22 am

    #1632372

    Here

    CLUSTER SHARED DISK AVAILABLE CHECK (FAILED)

  • July 15, 2013 at 8:12 am

    #1632480

    The cluster cannot see any shared disks

    have you presented the storage to all nodes that will participate in the failover cluster instance?

    have you added the new storage to the cluster available storage group?

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

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

  • July 15, 2013 at 11:11 pm

    #1632751

    Please see that

    the shared storage can be seen on both machines when one fail.

    Let me explain to you.

    There are two nodes and 1 san.

    shared storage are configured on SAN.

    After configured cluster i can see shared storage on primary machine. when i shutdown the primary machine the storage automatically copy to secondary machine.

    Now i am trying to install 2nd instance and these DISK issue came please help me to resolve this.

    Thanks in advanced.

  • July 16, 2013 at 12:10 am

    #1632758

    adeel.imtiaz (7/15/2013)

    Please see that

    the shared storage can be seen on both machines when one fail.

    Let me explain to you.

    There are two nodes and 1 san.

    shared storage are configured on SAN.

    After configured cluster i can see shared storage on primary machine. when i shutdown the primary machine the storage automatically copy to secondary machine.

    Now i am trying to install 2nd instance and these DISK issue came please help me to resolve this.

    Thanks in advanced.

    Ah now i see.

    You have no available storage for the new clustered instance, all previous disks have been claimed by the first instance.

    To install a new instance you will need further new LUNs added to the clusters available shared storage group.

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

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

  • July 16, 2013 at 12:45 am

    #1632767

    Each instance you are installing on a cluster needs their own cluster group. You can't use the same cluster group for multiple SQL instances. Each cluster group for SQL must have their own storage cluster resources.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 8 posts - 1 through 7 (of 7 total)

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