The Warehouse and Analysis databases for TFS can easily be migrated to a different SQL server. This article details the steps involved in the migration. Screenshots and examples provided are for TFS 2013 versions.
There are two ways to do it:
It is advised to make a note of the Default Folder Location for reports from the Reports Folder tab, under the Team Project Collections node on the TFS Admin Console and ensure that the same values are present after the migration
Also make a note of the settings for the Report Server details from the Reporting node. (Click on edit and navigate to Reports tab)
You should be a member of the following groups to perform the migration:
Content created by – Sreeraj Rajendran Content reviewed by – Romit Gulati