November 2006
Intermediate to advanced
521 pages
14h 16m
English
Backing up Team Foundation Server mostly requires backing up the data tier. In addition, you need to back up the symmetric encryption key from the report server.
Eleven databases, shown in the following table, make up the Team Foundation Server data tier:
| Database Name | Database Function |
|---|---|
| ReportServer | This is the SQL Server Reporting Services database. It contains all the reports, settings, and other information related to Reporting Services. |
| ReportServerTempDB | This is used by SQL Server Reporting Services to temporarily hold information needed for running reports. |
| STS_Config | This is used by Windows SharePoint Services to hold configuration information for the different Team Project WSS sites. |
| STS_Content_TFS | This is used by Windows SharePoint Services to hold the content of the different Team Project WSS sites. |
| TfsActivityLogging | This is used by Team Foundation Server to maintain a history of all Web server requests made to Team Foundation Server. |
| TfsBuild | This is used by Team Foundation Server to hold all build information and related data, such as test results. |
| TfsIntegration | This is used by Team Foundation Server to hold registration data on projects, areas, and iterations, among other items. |
| TfsVersionControl | This is used by Team Foundation Server to hold all information related to the Team Foundation version control system. |
| TFSWarehouse | This is the SQL Server Analysis Server database used by Team Foundation ... |