Full-text catalog ''TeamFoundationServer10FullTextCatalog'' is in an unusable state. Drop an
We are currently getting this error:
Full-text catalog 'TeamFoundationServer10FullTextCatalog' is in an unusable state. Drop and re-create this full-text catalog.
I found this potential fix online:http://notsosmartbuilder.blogspot.com/2007/08/moving-team-foundation-server-from.html
Since wearen'tsupposedto monkey directly with the TFS databases, I was wondering what the "recommended" solution to recreate these catalogs would be? Thanks!
~Jon
[736 byte] By [
Bebo] at [2008-1-9]
What version of TFS are you currently using ? Is it RTM or SP1 or Orcas Beta 2 ?
The best thing to do would be to manually drop the unusable catalog and then run TFS Repair. The repair will recreate the full text catalog and the indexes associated with it.
Let us know how it goes
Thanks
-Rajesh
I'm running the released TFS with SP1.
I got it fixed. I went to SQL Server Management Studio --> Object Explorer --> Databases --> TfsWorkItemTracking --> Storage --> Full Text Catalogs --> TeamFoundationServer10FullTextCatalog, right-clicked and chose Rebuild.
That was easy enough. ;-)
~Jon
