Rebuilding Warehouse Database in Team Foundation Server

When you restore, recover or failover the data-tier TFS, you need to rebuild the warehouse and cube to access high-level reports. Also, if you move or delete a team project collection, you need to reconstruct the warehouse and analysis cube. The warehouse for Team Foundation totals all operational data from other subsystems in Team Foundation Server. The warehouse corresponds to the DB, Tfs_Warehouse, and the cube resembles to the SQL Server Analysis Services DB, Tfs_Analysis.

Team Foundation Server performs below steps when you choose to rebuild the warehouse:

Takes the DBs offline.
Drops the schema for both DBs.
Re-creates the schema for both DBs.
Brings both DBs back online.
Restarts the warehouse adapter jobs.
Processes the cube according to its regular processing interval.

With the rebuild operation, you re-create both the DB and the cube. Team Foundation Server rebuilds the DB from the operational data stores. It then re-creates the SQL Server Analysis Services cube and processes the cube to populate it by using data from the DB. If you want to rebuild just the cube, you can use the TFSConfigRebuildWarehouse command-line tool.

To rebuild the data warehouse:

Launch the administration console for Team Foundation.
Under Team Foundation, expand the name of the server, expand Application Tier, and then click Reporting.
Under Reporting, click Start Rebuild.
Click OK to take the data warehouse and Analysis Services cube offline.
Click OK to initiate the rebuild process.
The rebuild process starts first for the warehouse and then for the cube. The time that is required to rebuild the DBs is based on the amount of data that is stored in the data warehouse. When the DBs have been rebuilt, the jobs for processing the DBs are automatically started.
Restart the RFSINSTANCE service.