troubleshooting Question

SQL Upgrade (in place)

Avatar of careybroph
careybrophFlag for United States of America asked on
Microsoft SQL Server
4 Comments1 Solution27 ViewsLast Modified:
Currently running:
  • MS SQL Standard 2014 SP3 (64bit)
  • Windows Server 2016 Datacenter

I need to upgrade to SQL 2019 and (for a plethora of reasons), I'd like to do an upgrade-in-place. Could I setup a new server, install all new software, migrate my data, and then change around server names / IP addresses and such? Yes. And we've done that in the past. But it's a painful process that involves multiple folks from various other departments... and it has to be done in the wee hours.

If it's possible (and not a terribly egregious) mistake, I'd much prefer to do an in-place upgrade. It's a VM, so I can snapshot the system beforehand, providing a full recovery option.  My approach would be to take SQL Server offline, do a VM snapshot, upgrade, bring back online, test critical systems. If all is good, great. If not, I can restore the VM snapshot and regroup.

As this is the place to get "expert" advice, I'd really appreciate any thoughts the experts can provide. I have no concerns about actually installing the upgrade. I've been in the IT field for a long time and I've used SQL for many, many years, but not as a power-admin. And this is the first time I've considered this approach, so my experience is limited. As Clint Eastwood would say... "A man's got to know his limitations". So, here I am.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros