locked
Moving SQL Server Cluster Resources. RRS feed

  • Question

  • Hi experts,

    One of our customer is having a two node SQL cluster on Windows Server 2008 OS.

    The cluster group configuration is as follows (SQL Cluster implemeted by Customer itself)

    Resource     

    Group    

    Node    

    Status

    Cluster Disk 1      

    SQL Server (MSSQLSERVER)

    SQL-DWDB02  

    Online

     

    Cluster Disk 60     

    Cluster Group                    

    SQL-DWDB01  

    Online

     

    Cluster IP Address 172.16.0.180

    Cluster Group       

    SQL-DWDB01  

    Online

     

    Let me come to the acutal point now.

    Customer invited one of our  HP Data Protector experts for configuring backup for the above mentioned sql cluster. Unfortunately he failed to configure the same and escalted the same to HP support team.

    After several investigation HP support team claims that the sql cluster resources should be moved from its cluster group named "SQL Server (MSSQLSERVER)" to the default cluster group "Cluster Group".

    My questions are...

    1. How to move the SQL cluster resources from "SQL Server (MSSQLSERVER)" cluster group to the default cluster group "Cluster Group"?
    2. If the movement is possible, will it effect the current setup?

    Experts your earliest support will be appreciable.

    Thanks,

    Santhosh

                                                          

     

     

     

     

     

     

     

     

     

     

     

     


    Santhosh Sivaraman MCITP: Microsoft Exchange Server 2007/2010 | MCSE/MCSA

    Monday, April 25, 2011 8:52 AM

Answers

  • Dear All,

    For backing up sql server cluster database using HP data protector, it is not mandatory to put the sql cluster resources into the default cluster group.

    Finally I have visited the customer site and requested them to take the backup of a small database.

    It was working fine.

    Thanks,

    Santhosh

     

     

     


    Santhosh Sivaraman MCITP: Microsoft Exchange Server 2007/2010 | MCSE/MCSA
    Saturday, May 7, 2011 5:50 AM

All replies

  • Hi Santhosh,

    You can use the "Change Group" option as shown in the below screenshot.

     

     

    It is always recommended to have SQL Server resource in a separate group. However, moving the group should not have any adverse affect on the existing setup.




    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga

    Monday, April 25, 2011 10:47 AM
  • Hi Santhosh,

    You can use the "Change Group" option as shown in the below screenshot.

     

     

    It is always recommended to have SQL Server resource in a separate group. However, moving the group should not have any adverse affect on the existing setup.




    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga


    Hi Pradeep,

    Thanks for your reply and you are correct.

    The SQL Cluster is running on Windows Server 2008 not on Windows Server 2003.

    Sorry I forgot to mention the same on my post.

    Thanks,

    Santhosh

     


    Santhosh Sivaraman MCITP: Microsoft Exchange Server 2007/2010 | MCSE/MCSA
    Monday, April 25, 2011 1:07 PM
  • Santhosh,

    Check if this post helps.




    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga

    Monday, April 25, 2011 2:11 PM
  • Santhosh,

    Check if this post helps.




    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga


    Pradeep,

    Thanks for your response.

    It didn't help me as you expected.

    If your expertise getting some another information pls do help me.

    Thanks,

    Santhosh


    Santhosh Sivaraman MCITP: Microsoft Exchange Server 2007/2010 | MCSE/MCSA
    Tuesday, April 26, 2011 4:07 AM
  • Dear All,

    For backing up sql server cluster database using HP data protector, it is not mandatory to put the sql cluster resources into the default cluster group.

    Finally I have visited the customer site and requested them to take the backup of a small database.

    It was working fine.

    Thanks,

    Santhosh

     

     

     


    Santhosh Sivaraman MCITP: Microsoft Exchange Server 2007/2010 | MCSE/MCSA
    Saturday, May 7, 2011 5:50 AM