It’s that time of the IT lifecycle again, where we talk upgrades and decommissioning. On the 12th July 2022, Microsoft SQL Server 2012 will go End of Life. Not just to extended/security patch support, but completely out of support.

So, why am I talking about Veeam? If you’ve got an installation of Veeam that utilised a SQL Server Express database, and you installed Veeam prior to 9.5 Update 4, odds are you’ve got a SQL Server 2012 Express database. This creates a security risk as of the next Microsoft patch cycle, scheduled for the 12th July 2022. Which version of SQL Server should I migrate to? I would also like to state that whilst this isn’t the focus of the article, if you’ve got a Veeam Backup & Replication or Veeam ONE environment that’s not running v11 yet, you really need to upgrade, as everything prior is at end of fix. Unless you are limited by the operating system support for SQL Server 2019, I don’t recommend going for anything older. This is because SQL Server 2017, whilst still in mainstream support for now, enters extended support in October 2022, mere months away. How can I upgrade my SQL Server instance? SQL Server 2022 is only in public preview, making it a poor candidate for production platforms at present. In more words, you can’t perform an ‘in-place upgrade’. We’ll need to install the newer edition of SQL Server, either on a new server, or alongside your existing SQL Server instances, and then migrate the data across. With that out of the way, let’s start with installing the new SQL Server edition.

Free realistico full