Upgrade scenario walkthrough for Azure DevOps Server

TFS 2017

This quickstart covers a typical Team Foundation Server (TFS) upgrade scenario to get a sense of what the high level steps discussed in the overview might look like in a real world example.

Prepare your environment

Our starting point for this upgrade is a TFS 2012 Update 4 environment with two machines - one serving as the application tier and a second serving as the data tier for both the config/collection databases, and the reporting and analysis services databases. Both machines are currently running Windows Server 2008 SP2, and the data tier is currently running SQL Server 2008 R2.

Our first step is to check the system requirements for TFS 2015. Unfortunately, neither the OS nor the SQL version we are using are still supported, so we will need to make some changes. We decide to take the opportunity to acquire two more powerful machines, and we install Windows Server 2012 R2 on both of them. We install SQL Server 2014 on the data tier, making sure to include Reporting Services and Analysis Services, since we are using those features in our deployment. Our environment is prepared.

Expect the best, prepare for the worst

We have been using scheduled backups to ensure that we always have backups in place in case something goes wrong.

For our dry run, the steps for our upgrade will be:

  1. Copy recent database backups to our new SQL instance.
  2. Install TFS 2015 on our new application tier.
  3. Use scheduled backups to restore the database backups.
  4. Run through the upgrade wizard, being sure to use a service account which does not have any permissions in our production environment.
  5. Optionally configure new features which require changes to our existing projects.

Do the upgrade

Assuming that all goes smoothly, the production upgrade steps will be quite similar. There the steps will be:

  1. Take the production server offline using TFSServiceControl's quiesce command. The goal here is to ensure that the backups we use to move to our new hardware are complete and we don't lose any user data.
  2. Take new backups of each database.
  3. Copy the backups to our new SQL instance.
  4. Install TFS 2015 on our new application tier.
  5. Use the scheduled backups wizard to restore the database backups.
  6. Run through the upgrade wizard, using our desired production service account.
  7. Optionally configure new features which require changes to our existing projects.

And we're done!