Freitag, 9. März 2012 17:32
I tried to rebuild my Tfs_Analysis, as it got corrupted ("Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.1712.cub.xml'.", etc).
I followed the instructions mentioned here: http://blogs.microsoft.co.il/blogs/oshryhorn/archive/2011/02/20/how-to-fix-tfs-analysis-when-it-is-corrupt.aspx (stop analysis services, delete Tfs_Analysis files, start the service, start rebuild from TFS Administration Console - Reporting).
When I try to start rebuild, an error occurs:
TF255322: The installation parameters specify the use of an existing database, but the database could not be found. The database name is: Tfs_Analysis. The server hosting the database is <tfs server name>".
When I log to Analysis Services using MSSMS I see there is indeed no Tfs_Analysis DB there.
I found many manuals advising to drop Tfs_Analysis (and Tfs_Warehouse) before rebuilding them, so I assumed having Tfs_Analysis DB is not necessary to rebuild (also, rebuild procedure is supposed to drop them anyway), but it looks like they are.
What can I do now? I don't have Tfs_Analysis backup (what's the point if I can always rebuild it?...).
Montag, 12. März 2012 04:30Moderator
Thanks for your post.
According your description, you already deleted the Tfs_Analysis database from your Analysis Service.
I suggest you recreate the Tfs_Analysis database and Tfs_Warehouse database using TFS Admin Console, then try to rebuild. Please refer to the detailed steps in this article: http://mohamedradwan.wordpress.com/2010/10/29/how-to-recreate-the-data-warehosue-and-the-analysis-service-for-tfs/.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
- Als Antwort markiert John QiaoMicrosoft Contingent Staff, Moderator Donnerstag, 15. März 2012 05:31