Follow this article if you are planning to migrate the Report Server being used with your TFS deployment to a new hardware. The migration requires the report server databases, reportserver and reportservertempdb which are in use with the current deployment of TFS reporting, to be moved across to the new SQL instance.
These two databases are related by their names (tempdb will be appended to the name specified for the report server database during the configuration of Reporting Services, for the second database). The databases are referred as reportserver and reportservertempdb in the rest of the article, for convenience. Please read them as the actual Report Server databases for your deployment.
You should be a member of the following groups to perform the migration:
Content created by – Sreeraj Rajendran Content reviewed by – Romit Gulati