Skip to main content
Solved

Commserver OS getting upgraded to windows 2016 but current SQL server version is 2012 Enterprise SP4 for Commserver.

  • February 11, 2023
  • 4 replies
  • 320 views

Forum|alt.badge.img

Commserver OS getting upgraded to windows 2016 but current SQL server version is 2012 Enterprise SP4 for Commserver. Is windows server OS 2016 still supporting SQL server 2012 SP4 for commserver?. I know hardware refresh is one option but that would be last option i am looking out for currently . Please someone confirm the compatibility matrix for me. Commserver is a VM and we will have a snapshot in place just incase we run into an issue

Best answer by Damian Andre

Commvault stopped supporting SQL 2012 as a CommServe platform last year - releases beyond FR30 (2023 platform release) will not allow you to update while SQL 2012 is in place as they are taking advantage of new SQL features found in 2016 and beyond for better scale and performance.

Note that Microsoft Windows 2016 ended mainstream support last year too - so probably better to adopt a newer version if you can.

The best option here is a HW refresh with a fresh reinstall of the CommServe on Windows 2019 or newer. That will bring SQL up to SQL 2019 which will be supported for a long time and you wont have to worry about the OS for a while.

There are quick instructions on this page: https://documentation.commvault.com/2022e/essential/142604_upgrading_microsoft_sql_server_editions_on_commserve_computer.html

Be very careful leveraging a snapshot rollback as a DR plan - it can cause all sorts of issues by desyncing with the deduplication databases, disk library etc.

View original
Did this answer your question?

4 replies

Forum|alt.badge.img+14

HI @Rohit1984 ,

SQL server 2012 is not supported anymore:

https://documentation.commvault.com/2022e/expert/2801_commserve_server_system_requirements_windows.html#database-engine

Please also check the Microsoft website:

https://www.microsoft.com/en-us/sql-server/sql-server-2012-eos#:~:text=End%20of%20Support%20for%20SQL,support%20on%20October%2010%2C%202023

End of Support for SQL Server 2012 and Windows Server 2012 and 2012 R2. SQL Server 2012 reached end of support on July 12, 2022, and Windows Server 2012 and 2012 R2 reaches end of support on October 10, 2023.

Best Regards,

Sebastien

 


Zubair Ahmed Sharief
Vaulter
Forum|alt.badge.img+11

Hello @Rohit1984 

I think you should follow the below steps.

  1. Run a DR backup before OS Migration to OS 2016; Take a VM Snapshot
  2. Once OS is Migrated, reinstall CV (will install compatible SQL Version) and recover from DR backup (keep the DR folder accessible from new server for this to happen)

Let us know if that helps!


Onno van den Berg
Commvault Certified Expert
Forum|alt.badge.img+19
  • Commvault Certified Expert
  • 1252 replies
  • February 13, 2023

@Rohit1984 why not upgrade to Windows 2022 or Windows 2019? 


Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Vaulter
  • 1301 replies
  • Answer
  • February 14, 2023

Commvault stopped supporting SQL 2012 as a CommServe platform last year - releases beyond FR30 (2023 platform release) will not allow you to update while SQL 2012 is in place as they are taking advantage of new SQL features found in 2016 and beyond for better scale and performance.

Note that Microsoft Windows 2016 ended mainstream support last year too - so probably better to adopt a newer version if you can.

The best option here is a HW refresh with a fresh reinstall of the CommServe on Windows 2019 or newer. That will bring SQL up to SQL 2019 which will be supported for a long time and you wont have to worry about the OS for a while.

There are quick instructions on this page: https://documentation.commvault.com/2022e/essential/142604_upgrading_microsoft_sql_server_editions_on_commserve_computer.html

Be very careful leveraging a snapshot rollback as a DR plan - it can cause all sorts of issues by desyncing with the deduplication databases, disk library etc.


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