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