Tuesday, November 02, 2010 8:16 AM
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.
- Edited by Tony Fabian Tuesday, November 02, 2010 8:18 AM spelling error
Tuesday, November 02, 2010 9:22 AMJust ran the best practices analyzer and it did not report any issues.
Tuesday, November 02, 2010 9:42 AM
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."
- Marked As Answer by Tony Fabian Tuesday, November 02, 2010 9:42 AM
Wednesday, January 25, 2012 12:45 AM
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
It did not mention the TfsWarehouse database, does this mean I don't need this database and I can safely delete this database?
Thursday, February 09, 2012 1:21 PM
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.
Monday, February 20, 2012 2:51 PMSame here, I'd like to know if I need to backup "TfsWarehouse" (without the underscore), or If I can delete it.
Monday, February 20, 2012 9:41 PMCount me in as another interested party looking for an answer to this question.
Friday, March 16, 2012 11:58 AM
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.