Migrating Team Foundation Server 2013 Databases and all Databases in SharePoint 2013 to a New Server

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:

  1. Installing MS SQL Server 2014
  2. Stop IIS and all TFS Services
  3. Stop IIS and all SharePoint Services
  4. Share a folder and turn off firewall
  5. Backup DBs and store them on the shared folder
  6. Backup SQL Server Reporting encryption key
  7. Restore DBs to the new SQL Server machine
  8. Remap Reporting DB and restore encryption key
  9. Remap and configure TFS for the new DB server
  10. Remap and configure SharePoint for the new DB server
  11. Start IIS and all TFS Services again
  12. Verify SharePoint DB migration
  13. Verify TFS DB migration
  14. Note-1 DotNet Framework cannot be installed
  15. Note-2 Fix SharePoint error cannot open DB
  16. Note-3 Fix SharePoint error cannot open sites
  17. Note-4 Repair TFS connection with SharePoint
  18. Note-5 Analysis DB backup and restore

 

1-Installing MS SQL Server 2014

2-Stop IIS and all TFS Services

3-Stop IIS and all SharePoint Services

4- Share a folder and turn off firewall

5-Backup DBs and store them on the shared folder

6-Backup SQL Server Reporting encryption key

7-Restore DBs to the new SQL Server machine

8-Remap Reporting DB and restore encryption key

9-Remap and configure TFS for the new DB server

10-Remap and configure SharePoint for the new DB server

11-Start IIS and all TFS Services again

12-Verify SharePoint DB migration

13-Verify TFS DB migration

14-Note-1 DotNet Framework cannot be installed

15-Note-2 Fix SharePoint error cannot open DB

16-Note-3 Fix SharePoint error cannot open sites

17-Note-4 Repair TFS connection with SharePoint

18-Note-5 Analysis DB backup and restore


Share This: