SQL Server Blog

SQL Server Upgrade Checklist

Last week, I wrapped up the delivery of a 4-part webinar series giving tips about SQL Server upgrades. I talked about how critical a SQL Server Upgrade Checklist is to the success of your SQL Server upgrade projects and promised a checklist. Here it is! This is a free download, no e-mail address required.

Check out our SQL Server Upgrades Made Easy webinar series.

Why a SQL Server Upgrade Checklist?

Frankly, why not?! Pilots use checklists. Surgeons use checklists. The military uses them. Checklists help make sure no routine steps are missed, and they can make life a lot easier when you end up in an abnormal situation! Sure, at Straight Path, we do SQL Server upgrades a lot – we are consultants, so we work with a lot of clients. But for the average DBA who stays with a company for a long time, you can’t go wrong making your own SQL Server upgrade checklist!  

When an upgrade goes bad? It can get ugly quick. Your checklist will keep your upgrade running smooth. We remind you of a few things like having the right team in place, having a rollback plan, setting up the right order of operations. Combine the SQL Server Upgrade Checklist with our SQL Server Build Guidelines (JON LINK!!!)  and you’ll be off to a good start.

So… Start with our SQL Server Upgrade Checklist if You Want!

I told you that you need to have one. I hope you agree. Rather than pontificate on the reasons why, I’ll give you a free “start” – you can download Straight Path’s SQL Server Upgrade Checklist. You’ll note the disclaimer in the download and below. This isn’t the end-all-be-all for your SQL Server upgrade steps. We can’t write a SQL Server upgrade checklist that covers every single scenario. This is really meant to be a start for you to start your own checklist. Just use it. You don’t need to mention us, steal what works, test it, throw away what doesn’t. Leave a comment with things you’d add and we’ll periodically update this document and maybe keep a running (UPDATED: ) log at the bottom. And maybe make a new post when we do update it so if you subscribe to the blog, you’ll see it.

Our goal here is to help you out where you are. Sure. We do consult for SQL Server upgrade projects. You can always set up a free meeting to chat with me if you think you need a little help. But seriously, evaluate your needs, do your checklist yourself and see if you even need the help first! You may not!

An Excerpt from The Checklist

From the intro. There are very few paragraphs in this. It’s mostly checkmark bullets!

SQL Server upgrades don’t have to be stressful! In 2019, Straight Path’s founder, Mike Walsh, walked folks through the things to consider before, during, and after a SQL Server Upgrade process. You can watch the videos of this series over at our blog at the SQL Server Upgrades Made Easy page. (JON!! LINK)

This document can help you get on the way to having a SQL Server Upgrade checklist. You’ll need to cut and paste from this, add in the details about your own environment, test all the steps to be sure they work right for you and use this as a guide for your own checklist creation process. But please, take all you can from this and use this as the baseline for your own checklist! If you have a good rollback plan, you may physically have a second chance to do your upgrade right! Don’t burn the goodwill of your users and management by doing a SQL Server upgrade without planning!

At Straight Path, we help a lot of folks with SQL Server upgrades. We still double and triple check the basics and rely on checklists for success!
This document won’t answer your questions and do the steps for you! It would never end! It’s to get you thinking of the questions to ask and steps to do! Look to our blog and videos for some thoughts on possible answers to the steps!

For The Lawyers…

NOTE – AS ALWAYS – THIS IS A DOCUMENT FROM THE INTERNET WITH IDEAS FROM OUR TEAM AND BECAUSE YOU WILL BE ATTEMPTING THESE STEPS ON YOUR OWN AND INTERPRETATIONS MAY VARY, THIS IS OFFERED WITHOUT WARRANTY! YOUR MILEAGE MAY VARY AND YOU SHOULD TEST THESE PROCEDURES AND STEPS AND MAKE SURE THEY WORK FOR YOU AND YOUR ENVIRONMENT AND MAKE SURE YOU ARE ADDRESSING ALL RISKS UNIQUE TO YOUR ENVIRONMENT. THIS DOCUMENT IS PROVIDED AS A GUIDE FOR YOU TO CREATE YOUR OWN CHECKLIST! IT COMES FROM OUR KNOWLEDGE AND WISDOM AND THE MANY SUCCESSFUL UPGRADES WE’VE DONE! (Mike’s note – these really are the high level steps and some low level thoughts we use when we help someone do an upgrade)

Download Your Checklist

Mike Walsh
Article by Mike Walsh
Mike loves mentoring clients on the right Systems or High Availability architectures because he enjoys those lightbulb moments and loves watching the right design and setup come together for a client. He started Straight Path in 2010 when he decided that after over a decade working with SQL Server in various roles, it was time to try and take his experience, passion, and knowledge to help clients of all shapes and sizes. Mike is a husband, father to four great children, and a Christian. He’s a volunteer Firefighter and EMT in his small town in New Hampshire, and when he isn’t playing with his family, solving SQL Server issues, or talking shop, it seems like he has plenty to do with his family running a small farm in NH raising Beef Cattle, Chickens, Pigs, Sheep, Goats, Honeybees and who knows what other animals have been added!

Subscribe for Updates

Name

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Share This