Export (0) Print
Expand All

Team Foundation Server Databases

Team Foundation Server stores data in SQL Server and, if you have reporting configured, SQL Server Analysis Services and Reporting Services. You can better manage and administer your deployment if you understand what databases Team Foundation Server uses.

The following table describes the databases that might be present in your deployment of Team Foundation Server:

Database

Used If

Description

Tfs_Configuration

Always

Stores data that describes your deployment of Team Foundation Server, including the name and location of the other databases.

Tfs_Collection

Always

One database for each team project collection. Each database stores the data for the team projects (version control, builds, and work items) in that collection.

Tfs_Warehouse

Reporting is configured

Data from all project collections is collected and stored in tables that are optimized for reporting.

Tfs_Analysis

Reporting is configured

Analysis Services database that organizes the data from the warehouse database into a cube structure..

ReportServer

Reporting is configured

Stores reports and report configuration data for Reporting Services.

ReportServer_TempDB

Reporting is configured

Stores temporary reporting data for Reporting Services.

WSS_Config

Integration with SharePoint Products is configured

Stores configuration data about SharePoint Products.

WSS_Content

Integration with SharePoint Products is configured

Stores the content for the SharePoint Products sites.

WSS_AdminContent

Integration with SharePoint Products is configured

Stores the administration information for SharePoint Products.

Show:
© 2014 Microsoft