Skip to main content
Question

Commvault Upgrade and Commvault DB/MSSQL upgrade order


Forum|alt.badge.img+7

Hi!

 

We’re slowly planning some upgrades to our Commvault installasjon, where we’re planning to go from 11.24 to 11.32 (which i understand can be done with a direct upgrade from .24 to .32)….. but we also plan to upgrade the Commvault MSSQL installasjon, which is currently an older MSSQL versjon,

 

The question is, should we upgrade the DB first, or Commvault ? Any recommendation ?

5 replies

Forum|alt.badge.img+11
  • Vaulter
  • 241 replies
  • August 11, 2023

Hi Bjorn,

The easiest would be to follow documentation = https://documentation.commvault.com/2022e/essential/142604_upgrading_microsoft_sql_server_editions_on_commserve_computer.html

 

This involves uninstalling the CS and SQL Server and reinstalling with the newer FR release, this will also include SQL Server 2019. Then just run a CSRecoveryAssistant to restore the CS to its previous configuration.

 

Alternatively (although not within our documentation), you could run an SQL Server in-place upgrade if your current and target versions support it. In this case it won’t really matter if the CS or SQL Server are done first, since both should be in-place upgrades.

 

As a final note, if you are currently in SQL Server 2012 Enterprise, the only possible option if you plan to use the SQL Server bundled version with CV, will be to reinstall it, since we currently bundle SQL Server Standard Editions with our software and there is no direct in-place upgrade path from Enterprise to Standard.


Forum|alt.badge.img+4

Hello @Bjorn M 

 

Please refer to following BOL to perform upgrade of MS SQL Server edition for SP32 - https://documentation.commvault.com/2023e/essential/142604_upgrading_microsoft_sql_server_editions_on_commserve_computer.html

 

Please ensure that you have a healthy DR backup for a roll-back if needed.


Forum|alt.badge.img+7
  • Author
  • Byte
  • 42 replies
  • August 11, 2023

Thanks @Javier and @Tanuj Balani !

 

Sounds like doing both upgrades at the same time/process is the most effective way.


Forum|alt.badge.img+5
  • Byte
  • 12 replies
  • August 11, 2023

Hi Bjorn

I have recently upgraded from 11.24 to 11.28, which also involved upgrading the SQL DB from 2012 following the books online.

Painless, finished in about 75 minutes from shutting down to starting up, no issues on startup!

If you are running the Commserve on a virtual server, take that just in case snapshot

And make sure you have a note of the directories where your binaries, SQL DBs and DR Backup lie, as you are asked this during the installation

Good luck

Mark


Forum|alt.badge.img+1
  • Byte
  • 3 replies
  • January 4, 2024

We are planning to upgrade from 11.28.100 to 11.32.38 FR. 
minimum SQL DB version is 13.x and 14.x
and minimum Oracle DB version is 11.2 and 12.1

Can someone tell if it is compatible and good to upgrade


Reply


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