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