Full Text - Cannot Delete

We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
name etc. Everything is working fine with the exception of one database. The
issue is that this database full text index is pointing to 'D:\MSSQL
Catalogs' which does not exist anymore. Is there a way to remove the full
text index and recreate it? I get errors when I try to delete it. I get
error 20565 - database is not full-text enabled yet. I use the exec
sp_fulltext_database 'enable' command and receive -
(1 row(s) affected)
(0 row(s) affected)
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
cannot be created. Only directories on a disk in the cluster group of the
server can be used.
Thank you!
Backup your database. Kick all users off it. Then using EM right click on
the tables you are full-text indexing and delete the full-text indexes on
them. When you have completed this, try to create another catalog, delete it
through EM, and then delete the contents of sysfulltextcatalogs.
If this doesn't work try this in QA
sp_help_fulltext_catalogs
to get the names of your fulltext catalogs and then try
declare @.int int
declare @.string varchar(200)
Create table holding
(
TABLE_OWNER sysname,
TABLE_NAME sysname,
FULLTEXT_KEY_INDEX_NAME sysname,
FULLTEXT_KEY_COLID int,
FULLTEXT_INDEX_ACTIVE int,
FULLTEXT_CATALOG_NAME sysname)
insert into holding
exec sp_help_fulltext_tables 'test1234'
select @.int = @.@.rowcount
while @.int>0
begin
select @.string='sp_fulltext_table ''' +table_name+''',''drop''' from holding
exec (@.string)
delete from holding
select @.int=@.int-1
end
exec sp_fulltext_catalog 'CatalogName','drop'
GO
"Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
news:%23r71zSgfHHA.4596@.TK2MSFTNGP05.phx.gbl...
> We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
> name etc. Everything is working fine with the exception of one database.
> The issue is that this database full text index is pointing to 'D:\MSSQL
> Catalogs' which does not exist anymore. Is there a way to remove the full
> text index and recreate it? I get errors when I try to delete it. I get
> error 20565 - database is not full-text enabled yet. I use the exec
> sp_fulltext_database 'enable' command and receive -
> (1 row(s) affected)
> (0 row(s) affected)
> Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line
> 61
> Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
> cannot be created. Only directories on a disk in the cluster group of the
> server can be used.
> Thank you!
>