You can restore data for Team Foundation from one data-tier server to another but keep the same application-tier server. For example, you might want to move the data tier when you upgrade its server hardware. Moreover, you might need to create a data-tier server if the original server fails unexpectedly. This process differs from moving your whole deployment of Team Foundation Server (application tier and data tier) from one set of hardware to another. For more information, see Team Foundation Server Move Types.
Required Permissions
To perform these procedures, you must be a member of the following groups:
* Administrators group on the data-tier and application-tier servers
* Team Foundation Administrators group
* Windows SharePoint Services Site Administrator group
* SQL Server Administrator group on the data-tier server
For more information, see Team Foundation Server Permissions.
In addition to these permissions, you might need to address the following requirements on a computer that is running Windows Server 2008 or Windows Vista:
* To follow a command-line procedure, you might need to open an elevated Command Prompt by clicking Start, right-clicking Command Prompt, and clicking Run as Administrator.
* To follow a procedure that requires Internet Explorer, you might need to start it as an administrator by clicking Start, clicking All Programs, right-clicking Internet Explorer, and then clicking Run as administrator.
* To edit web.config files, you might need to start the text editor as an administrator by clicking Start, clicking All Programs, right-clicking the editor, and then clicking Run as administrator.
* To access Report Manager, reports, or Web sites for SQL Server Reporting Services, you might need to add these sites to the list of trusted sites in Internet Explorer or start Internet Explorer as an administrator.
For more information, see the Microsoft Web site.
To restore data for Team Foundation to a different data-tier server, you must complete the procedures in the following sections in the sequence listed:
1. Back Up Data
2. Install and Configure SQL Server on the New Hardware
3. Restore the Databases
4. Redirect Web Sites for Team Projects
5. Reconnect the Administration and Configuration Databases
6. Redirect and Test SQL Server Reporting Services and Default Reports
7. Redirect the Application-Tier Server to the New Data-Tier Server
8. Rebuild the Team System Cube
9. Delete the Version Control Cache
10. Update Service Accounts
11. Restart Services
12. Refresh the Data Cache on Client Computers