Hey there, fellow tech enthusiasts! I’m about to share a puzzling experience I had with a SQL Server upgrade, and I’m hoping someone out there can shed some light on what’s going on.
I recently tried to upgrade my MS SQL Server from 2019 to 2022. Sounds straightforward, right? Well, it wasn’t. After running the install, I chose all the proper upgrade options, and it seemed to complete successfully. But here’s the kicker: when I ran `SELECT @@VERSION`, it still showed the database version as 2019!
I was stumped. I’d done plenty of upgrades and installs before, but this one had me scratching my head. I even went so far as to nuke my test server, re-clone it, and try the upgrade again, being super careful to choose the right options. Same result.
What really threw me off was that Programs and Features showed both versions installed, as if it had done a parallel install. But during the upgrade, I specifically chose to upgrade the existing instance, and it was the only instance present.
I’m still not sure what I did wrong or where to look to troubleshoot further. The text file output after install looked normal, but something clearly didn’t go as planned.
Has anyone else out there experienced something similar? Any suggestions or insights would be greatly appreciated!