This post could be used for many scenarios as the following:
Scenario 1: Migrate Team Foundation Server’s SQL Server to another machine, Migrating Team Foundation Server Databases, moving TFS configuration Database to another SQL Server
Following steps: Step-1, step-2, step-4, step-5, step-6, step-7, step-8, step-9, step-11, step-13
Scenario 2: Move all databases in SharePoint 2013, Moving SharePoint Content Databases to a New Server, Migrate SharePoint’s SQL Server to another SQL Server, Moving SharePoint to a different SQL server
Following steps: Step-1, step-3, step-4, step-5, step-7, step-10, step-12
Scenario 3: Migrating Team Foundation Server Databases and all databases in SharePoint 2013 to a New Server
Following steps: All steps
The list of all steps:
- Installing MS SQL Server 2014
- Stop IIS and all TFS Services
- Stop IIS and all SharePoint Services
- Share a folder and turn off firewall
- Backup DBs and store them on the shared folder
- Backup SQL Server Reporting encryption key
- Restore DBs to the new SQL Server machine
- Remap Reporting DB and restore encryption key
- Remap and configure TFS for the new DB server
- Remap and configure SharePoint for the new DB server
- Start IIS and all TFS Services again
- Verify SharePoint DB migration
- Verify TFS DB migration
- Note-1 DotNet Framework cannot be installed
- Note-2 Fix SharePoint error cannot open DB
- Note-3 Fix SharePoint error cannot open sites
- Note-4 Repair TFS connection with SharePoint
- Note-5 Analysis DB backup and restore