Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

RebuildWarehouse Command

You can use the RebuildWarehouse command to rebuild the SQL Server Reporting Services and SQL Server Analysis Services databases that Visual Studio Team Foundation Server uses.

To start the rebuild of these databases interactively, you can use the Reporting node in the administration console for Team Foundation. For more information, see Open the Team Foundation Administration Console.

Required Permissions

To use the RebuildWarehouse command, you must be a member of the following groups:

  • the Team Foundation Administrators security group and the Administrators security group on the server or servers that are running the administration console for Team Foundation

  • the sysadmin group on the server or servers that are running the instance of SQL Server that hosts the databases for Team Foundation Server

For more information, see Team Foundation Server Permissions.


Even if you log on with administrative credentials, you must open an elevated Command Prompt window to perform this function on a server that is running Windows Server 2008. To open an elevated Command Prompt window, click Start, right-click Command Prompt, and then click Run as Administrator. For more information, see this page on the Microsoft Web site: User Account Control.

TFSConfig RebuildWarehouse /analysisServices | /all [/ReportingDataSourcePassword:Password]




Specifies the password that the data sources account for SQL Server Reporting Services uses. This account is referred to in the documentation as TFSReports.




Required if /all is not used. Specifies that only the database for Analysis Services will be rebuilt. If no database exists for Analysis Services, you must also use the /reportingDataSourcePassword option.


Required if /analysisServices is not used. Specifies that all reporting and analysis databases that Team Foundation Server uses will be rebuilt.


Required if the TFS_Analysis database does not exist. Specifies the password of the account that is used as the data sources account for SQL Server Reporting Services (TFSReports). For more information, see Service Accounts and Dependencies in Team Foundation Server.

You might use this command when moving or splitting a team project collection, restoring data, or otherwise changing the configuration of your deployment.

The following example shows how to rebuild the Analysis Services database for a deployment of Team Foundation Server.


The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious.  No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred.

TFSConfig RebuildWarehouse /analysisServices
TFSConfig - Team Foundation Server Configuration Tool
Copyright © Microsoft Corporation. All rights reserved.
The Analysis Services database was successfully rebuilt.

Community Additions

© 2015 Microsoft