Tfs_warehouse and TFSWarehouse DB present after upgrading

Question

Hi,

After upgrading from TFS 2008 to TFS 2010 in a test environement i have noticed that i have 2 warehouse databases

One called Tfs_Warehouse and one called TFSWarehouse. The TFSWarehouse DB has the same name as the DB i restored from the production environment and i don't know why or if it should still be present after upgrading.

As far as i can see everything works fine. At least i can see the reporting services reports.

Can anyone sheed some light on if there is something wrong with my upgrade or if safely can ignorere this.

Kind regards

Tony

 

Answer 1

Just ran the best practices analyzer and it did not report any issues.

Answer 2

This is by design

"When you upgrade TFS 2005/2008 to TFS 2010, the old TFS databases are merged (6 of the 7 TFS databases are merged, only the TFSWarehouse database is left behind). This is by design. If you had seen the TFSVersionControl databse after upgrading to TFS 2010, then most possible that the Database list was not refreshed to show the latest. The upgraded instance of TFS 2010 will be left with TFS_Configuration, TFS_Collection, TFS_Warehouse and TFSwarehouse databases on the Database engine and TFS_Analysis and TFSWarehouse cube on the SQL Analysis engine."

http://social.msdn.microsoft.com/Forums/en-IE/tfssetup/thread/0c3724ba-bfde-413a-ac6c-1313ec62ffb0

 

Answer 3

Hi, Tony

Thanks for the explanation, I have the exact same situation after I  upgraded TFS2005 to TFS2010, now I got Tfs_Warehouse and TfsWarehouse.

My question is should I backup Tfswarehouse? Is TFS server still using this database?

I checked the following link for backup TFS 2010

 

http://msdn.microsoft.com/en-us/library/ms253070%28v=vs.100%29.aspx

 

It did not mention the TfsWarehouse database, does this mean I don't need this database and I can safely delete this database?

 

Thanks

Answer 4

I would also like to know if it is just a simple case of deleting the reports and data sources in the reportserver and then deleting the tfs_warehouse database. I don't see anywhere in the admin console that TFS knows about the 'old' tfs_warehouse.

Answer 5

Same here, I'd like to know if I need to backup "TfsWarehouse" (without the underscore), or If I can delete it.

Answer 6

Count me in as another interested party looking for an answer to this question. 

Answer 7

As written http://blogs.msdn.com/b/wlennon/archive/2009/12/02/upgrade-tfs-2010-from-tfs-2005-or-tfs-2008.aspx when describing migration upgrade:

You don't need TfsWarehouse.  That DB will be ignored. The warehouse gets rebuilt during upgrade.

So, I think, the answer is - Yes, you can delete this TfsWarehouse database.