5.2. Backing Up Team Foundation Server

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.

5.2.1. Backing Up the Team Foundation Server Databases

Eleven databases, shown in the following table, make up the Team Foundation Server data tier:

Database NameDatabase Function
ReportServerThis is the SQL Server Reporting Services database. It contains all the reports, settings, and other information related to Reporting Services.
ReportServerTempDBThis is used by SQL Server Reporting Services to temporarily hold information needed for running reports.
STS_ConfigThis is used by Windows SharePoint Services to hold configuration information for the different Team Project WSS sites.
STS_Content_TFSThis is used by Windows SharePoint Services to hold the content of the different Team Project WSS sites.
TfsActivityLoggingThis is used by Team Foundation Server to maintain a history of all Web server requests made to Team Foundation Server.
TfsBuildThis is used by Team Foundation Server to hold all build information and related data, such as test results.
TfsIntegrationThis is used by Team Foundation Server to hold registration data on projects, areas, and iterations, among other items.
TfsVersionControlThis is used by Team Foundation Server to hold all information related to the Team Foundation version control system.
TFSWarehouseThis is the SQL Server Analysis Server database used by Team Foundation ...

Get Professional Team Foundation Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.