corrupt full text catalogs -- can't delete!

I made an ameteur mistake moving my sql database.

I have 5 full-text catalogs and I thought they would come with the
backup...well, they didn't. Now, in Enterprise Manager, under full-text
catalogs, I can still see them. I cannot delete, rebuild, or do
anything with them though because I get an error about the object
missing. I tried to remove them via command line:

use dev_i3
EXEC sp_fulltext_catalog 'fcAttachment', 'drop'

but no luck.

There mus be a way to manually remove the reference to these catalogs
so I can rebuild them? I hope?!

Thanks in advance.

.

Relevant Pages

  • Re: Update to SP4 causes starnge Server behavior
    ... IIRC Service Pack 4 involves a ... rebuilding of your full-text catalogs. ... All full-text catalogs are rebuilt as part of the installation of SP4 when ... results or no results until the rebuild process is complete. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Cant get AND to work.
    ... empty the noise.enu or noiseenu.txt files and replace them with a ... single space. ... Then rebuild your catalogs. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SP4 and FT - can not find some words. Help...
    ... I have deleted and created FT catalogs. ... trackimg, background updating. ... >>> On the SQLServer SP3 my stored procedure worked fine. ... >>> I have install SP4 and rebuild FT catalogs. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full-Text Catalogs
    ... > If you restore the file to its original path, I think you don't even have ... > to rebuild the catalog. ... >> Books online states that only Meta Data of Full-Text Catalogs are backed ...
    (microsoft.public.cert.mcdba)
  • Re: [Info-ingres] Corrupt ii_encodings catalog
    ... Since this holds encoded 4GL frames and procedures, is it possible to rebuild it without having to do a rollforward. ... We've also got another database on this server, which is incidentally a test server, where they've been getting the same error on both iiattribute and iiqrytext.... ... Is it possible to rebuild these catalogs without a rollforward? ...
    (comp.databases.ingres)
Loading