O'Reilly logo

Professional Team Foundation Server by Mickey Gousset, Erik Gunvaldson, Jean-Luc David

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required