Skip to main content
Solved

SQL Cluster with multiple instances


Forum|alt.badge.img+2

We have a two-node SQL-Cluster with 10 SQL-Instances, load-balanced over the nodes.
Currently we fail to set up the backup. Only the instances running on node A are passing the backup successful. Instances on node B are failing with the following error:
[30:332] Description: Unable to get the SQL Version for the server

  • installed and check cv-software von slqcn1 and sqlcn2
  • added a windows-cluster in commvault and added sqlcn1 an sqlcn2 to this cluster
  • added all sql-instances to this windows cluster

Is this correct or do we have to create one cluster for each sql-instance in cv-software?

Best answer by Mike H

HI Sven, 

 

Based on your description, it sounds like you installed the SQL iDA on the using the cluster administrative access group (really the core cluster resource group).  That can ok assuming all of the role groups stay with which ever physical node owns that role, but if one group fails to another node you run into this situation (which is often the case).   Because of this situation, it is recommended to create a Cluster Group Client for every cluster resource group that contains data that you want to protect.

View original
Did this answer your question?

11 replies

Forum|alt.badge.img+6
  • Commvault Certified Expert
  • 40 replies
  • March 29, 2021

Hi Sven,

 

which version are you running on SQL and Windows? And are you using always on Availability groups?

be sure that there is also communication possible between the nodes and and that the backup account that you use is working with the same permissions on both nodes.

 


Forum|alt.badge.img+2
  • Author
  • Byte
  • 5 replies
  • March 29, 2021

SQL 2017, Windows 2016

No, we don’t use always on, it’s old-school failover cluster.

Are there any special ports needed from Commvault between the two hosts? The normal SQL-Ports are open from both sites.

The dedicated user has admin-permissions on both hosts and sysadmin on every instance.


Forum|alt.badge.img+6
  • Commvault Certified Expert
  • 40 replies
  • March 29, 2021

then its looks like that Node A is the active node of the cluster (with the cluster IP). Correct?
In that case Commvault is trying to backup also the SQL instance on Node B via Node A.


Forum|alt.badge.img+2
  • Author
  • Byte
  • 5 replies
  • March 29, 2021

Yes, Node A holds the cluster IP.

From Node A we can open all SQL instance running on node B (SQL Management Studio).

Is there a way to get more CV-Log-files? Debug-mode?

 


Forum|alt.badge.img+6
  • Commvault Certified Expert
  • 40 replies
  • March 29, 2021

You, can use the Commvault process monitor (gxadmin.exe in the base folder) to higher the debug level of agents.

you can also take a look at this data interface pairs

https://documentation.commvault.com/11.22/expert/7128_dedicated_backup_network.html


Forum|alt.badge.img+6
  • Commvault Certified Expert
  • 40 replies
  • March 29, 2021

but thinking of that further that is maybe not the best way to solve it.


Forum|alt.badge.img+2
  • Author
  • Byte
  • 5 replies
  • March 29, 2021
  • a higher log-lever doesn’t show more relevant informations.
  • a new try to backup the instance over his IP (instead of dns-name) ended with the same error.
  • backup with “use local system account” ended also with the same error

Forum|alt.badge.img+6
  • Vaulter
  • 35 replies
  • Answer
  • March 29, 2021

HI Sven, 

 

Based on your description, it sounds like you installed the SQL iDA on the using the cluster administrative access group (really the core cluster resource group).  That can ok assuming all of the role groups stay with which ever physical node owns that role, but if one group fails to another node you run into this situation (which is often the case).   Because of this situation, it is recommended to create a Cluster Group Client for every cluster resource group that contains data that you want to protect.


Aplynx
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • 288 replies
  • March 29, 2021

Each clustered object created in commvault should be assigned to a corresponding role on the cluster. 

A role would consist of a name, IP and disk resource.

The qourum is backed up by the system state of the physical machines so that one can be skipped.


Forum|alt.badge.img+2
  • Author
  • Byte
  • 5 replies
  • March 31, 2021

YES, finally it is working!

As you described, we had to create a cluster group for every single SQL-Instance.

Thanks for your great support.


Nikos.Kyrm
Byte
Forum|alt.badge.img+13
  • Byte
  • 192 replies
  • July 27, 2023
Sven Roth wrote:

YES, finally it is working!

As you described, we had to create a cluster group for every single SQL-Instance.

Thanks for your great support.


Hello @Sven Roth !

I guess these was the steps that you made for your SQL Cluster configuration:
(after 2:20)
 

Best regards,
Nikos


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings