Skip to main content
Solved

Commserve SQL version - How to check?


Craig A
Vaulter
Forum|alt.badge.img+2

How does a customer determine the MS SQL Version that is currently in use on the Commserve? Customer would like to check the version to determine if an upgrade is needed.

Best answer by Jacek Piechucki

Nothing easier than:
 

Then check global repository: https://sqlserverbuilds.blogspot.com/
 

 

View original
Did this answer your question?

4 replies

Michael Woodward
Commvault Certified Expert
Forum|alt.badge.img+11
  • Commvault Certified Expert
  • 79 replies
  • April 10, 2024

There’s a few ways.

If you have LiveSync configured, then the SQL agent for the LiveSync clients will display the SQL version at the Instance level:
 

The other is to launch SQL Server Configuration manager and on the services, right click → properties and then go to the Advanced Tab and see the File Version:

 

You can look up the file version or sql version online to give you the exact release, I normally use https://sqlserverbuilds.blogspot.com/

Alternatively if you have access to the SQL instance just run ‘select @@version’ as a query and it will tell you something like the following:

Then compare it to the list of certified releases in documentation and you’ll know if you need an upgrade. 

https://documentation.commvault.com/2023e/expert/commserve_server_system_requirements_windows_01.html

 

Hope this helps!


Erase4ndReuseMedia
Byte
Forum|alt.badge.img+13

If they have access to SQL Management Studio on the CommServe, they can run the following query:

SELECT @@version

Or via Command Line: 

SQLCMD -S <SERVERNAME>\COMMVAULT
SELECT @@version
GO

 


Nothing easier than:
 

Then check global repository: https://sqlserverbuilds.blogspot.com/
 

 


Craig A
Vaulter
Forum|alt.badge.img+2
  • Author
  • Vaulter
  • 3 replies
  • April 11, 2024

Thank you Jacek! 


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