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
View original
Userlevel 3
+9
- Commvault Certified Expert
- 66 replies
-
11 April 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.
Hope this helps!
If they have access to SQL Management Studio on the CommServe, they can run the following query:
SELECT @@versionOr via Command Line:
SQLCMD -S <SERVERNAME>\COMMVAULT
SELECT @@version
GO
- Vaulter
- 75 replies
-
11 April 2024
- Answer
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.