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 (TFS) 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 TFS

For more information, see Permission reference for Team Foundation Server.

Note

Even if you log on with administrative credentials, you must open an elevated Command Prompt window to perform this function.

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

Parameters

Placeholder

Description

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.

Option

Description

/analysisServices

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.

/all

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

/reportingDataSourcePassword:Password

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.

Remarks

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

Example

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

Note

The examples are for illustration only and are fictitious. No real association is intended or inferred.

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

See Also

Concepts

Team Foundation Server architecture

Understanding SQL Server and SQL Server Reporting Services

Add reports to a team project