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