The latest version of Microsoft SQL Server is SQL Server 2022 and was released in November 2022. If you are currently using a lower version, you might want to upgrade to a more recent version. Below is an interesting question that gave rise to this topic
To date, Veeam recommends using Microsoft SQL Server (MSSQL) instead of PostgreSQL in the following scenarios;
1: Large-Scale Deployments: When your Veeam Backup & Replication infrastructure manages thousands of VMs. MSSQL provides better scalability and performance.
2: Advanced MSSQL Features: Features like Always On Availability Groups etc are exclusive to MSSQL and can benefit large, high-availability environments: https://bp.veeam.com/vbr/2_Design_Structures/D_Veeam_Components/D_VBR_DB/database.html.
3: Veeam ONE Integration: Veeam ONE currently requires an MSSQL database. This guide will be beneficial to upgrade the engine as well.
Therefore, here is a guide for you if you wish to upgrade Microsoft SQL Server 2019 to 2022.
PostgreSQL Instead?
For those using PostgreSQL, there is a fantastic guide by
Note: PostgreSQL is sufficient for most environments with fewer than 5000 VMs.. Please see this guide for more information: https://www.veeam.com/blog/switch-sql-server-postgresql-veeam.html. Here is an alternative article on how to migrate Veeam Configuration Database to PostgreSQL Server
Looking ahead, Microsoft has announced SQL Server 2025 as discussed here: https://sqlserverbuilds.blogspot.com/. While the release date has not been officially confirmed, it is anticipated to be available later this year. When this is out, I will be describing the steps as well.
