Share via


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

Other Resources

Configuring Resources to Support Team Projects