Re: corrupt full text catalogs -- can't delete!

Can you place the full text index table in another catalog?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

<mattmerc@xxxxxxxxxxxxx> wrote in message
news:1138652646.375558.203680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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: FULL TEXT CATALOGS CANT BE OPEN
    ... Hilary Cotter ... Looking for a SQL Server replication book? ... > I have number of catalogs on my server. ... > catalogs section on the enterprise manager the enterprise manager is ...
    (microsoft.public.sqlserver.fulltext)
  • 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)
Loading