title: Move TFS Databases to a new SQL server
body: <p>Id like to confirm this with you.
  We are upgrading our TFS 2017 environment to use SQL 2016 SP2 in preparation of the TFS 2018 upgrade.
  Our SQL Team will do this using new hardware.</p>
  
  <p>I currently already use DNS aliases in my connection strings to the databases.</p>
  
  <p>Can you confirm this would be the steps in short?</p>
  
  <ul>
  <li>Run TfsServiceControl quiesce</li>
  <li>Migrate the database to the new server</li>
  <li>Update the DNS Aliases to point to the new host</li>
  <li>Run TfsServiceControl unquiesce</li>
  </ul>
  
  <p>Should it be that simple ? or should i take other steps to ensure the application is aware of the SQL Upgrade ?</p>
  
  <p>I was only able to find an old article about this subject
  <a href="https://blogs.msdn.microsoft.com/tfssetup/2014/05/15/migrating-team-foundation-server-databases/" rel="nofollow noreferrer">https://blogs.msdn.microsoft.com/tfssetup/2014/05/15/migrating-team-foundation-server-databases/</a></p>