SQL Server and Team Foundation Server
Visual Studio Team Foundation Server stores data in SQL Server and, if you have reporting configured, SQL Server Analysis Services and SQL Server Reporting Services. You can better manage and administer your deployment if you understand what databases Team Foundation Server uses and what permissions are required to manage these databases.
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. For more information, see Organizing Your Server with Team Project Collections. |
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. For more information, see Components of the Data Warehouse for Team Foundation. |
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. |
For more information, see the following page on the Microsoft Web site: Microsoft SQL Server. You must also synchronize the backups of these databases. For more information, see Back Up Team Foundation Server. Additional data might be stored in SQL Server if you have configured integration with SharePoint Products. For more information, see Interactions Between SharePoint Products and Team Foundation Server.
Important
If your server is running Windows Server 2008 or Windows Vista, you might not be able to access Web sites and tools for SQL Server unless you add those sites as Trusted Sites in Internet Explorer or start Internet Explorer as an administrator, even if you are logged on with administrative credentials. To start Internet Explorer as an administrator, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator. For more information, see the following page on the Microsoft Web site: User Account Control.
Common Tasks
Common Task |
Supporting Content |
|---|---|
Manage SQL Server databases: Ensure that the SQL Server services are available and operating correctly. |
|
Back up and restore databases: Create synchronized backups, and restore them to recover from a failure or to move to a different server. |
|
Upgrade reports and dashboards: You can upgrade the reports and dashboards available for your team projects after you upgrade your version of SharePoint Products from Windows SharePoint Services 3.0 to Microsoft Office SharePoint Server 2007 or Microsoft SharePoint Server 2010. |
|
Configure and manage reporting databases: You can configure reporting for your deployment of Team Foundation Server so that your teams can create and manage reports about their projects. |
|
Configure and manage databases for SharePoint Products |
See Also
Concepts
Team Foundation Server Architecture
Configuring Users, Groups, and Permissions
Organizing Your Server with Team Project Collections
The Team Foundation Administration Console
Understanding Administrative Concepts and Tools