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.
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.
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.
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.