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.