Forum Discussion

switchbone's avatar
switchbone
Level 3
11 years ago

Application HA clustering has dropped a disk... :-/

Hi, After I completed the Application HA clustering of SQL2008 across two Windows 2008 R2 nodes, I found that the SQL installation's virtual Backup disk (M: for reference) remained on the first nod...
Application monitoring
ApplicationHA
business continuity
Clustering
Error messages
Failover
High availability
Troubleshooting
User Group
Windows Server (2003-2008)
  • Wally_Heim's avatar
    Wally_Heim
    11 years ago

    Ok.  let me try this again.  My screenshots did not get added to my last post.  Here are two images to help you find the configuration information needed and where to put that information in the Cluster GUI.

     

    Capture1.PNG

     

    Capture2.PNG

     

    From your description, I'm also assuming that you have the other needed resource to mount the drive to M:. If not then we will need to modify or add other resources to get the drive completely accessible during failover.

    Thank you,

    Wally

switchbone's avatar
switchbone
Level 3
11 years ago

Actually Wally - I've hit another snag, which hopefully you can help with.blush

Following the Veritas™ Cluster Server Implementation Guide for Microsoft SQL Server 2008 and 2008 R2, I'm attempting to create the MSDTC resource group as explained in Chapter 7.

I have a separate disk (I: MSDTC) ready on the node I'm configuring the resource on, and I'm using SQL Server Agent Configuration Wizard to create the resource group with. 

After specifiying the name of the group and selecting both nodes of the cluster to configre the group on, I click Next and then receive the following error message:

Capture.JPG

I've done some research on the error but haven't found anything other than a patch: https://sort.symantec.com/patch/detail/7842 which includes the hotfix Hotfix_6_0_10011_3247363 and mentions the above error, but is intended to fix an issue with the "Windows FileShare" and "SQL Server 2008" agent configuration wizards.

Can you offer any advice on the error, please?

Thanks,

SB.