Lost Full Text catalog that won't delete!

[digitalKK]

During a server upgrade somehow the full-text catalog for a database
was lost. Now when I go into Enterprise manager I can't remove the old
catalog or create a new one!

How do I get rid of the current broken catalog and start a fresh?

[B D Jensen]

Hi!
what's your error message?

I had something similar, where the error message told me to backup log
file...
Greetings
Bjorn

[digitalKK]

On 6 Mar, 14:59, B D Jensen <[e-mail]:

Hi!
what's your error message?

I had something similar, where the error message told me to backup log
file...
Greetings
Bjorn

Hi Bjorn

Managed to sort it with the following:

-- Enable System Table UPDATEs
sp_configure allow,1
go
reconfigure with override
go

use <your_user_database_name>
go
-- Record FT Catalog info. (Note: path = NULL)
select * from sysfulltextcatalogs
go
UPDATE sysfulltextcatalogs set path = '<new_drive_letter:
\<new_directory>'
WHERE ftcatid = <ftcatid_of_affected_catalog>
go
-- Record new FT Catalog info.
select * from sysfulltextcatalogs
go

use master
go
-- Disenable System Table UPDATEs
sp_configure allow,0
go
reconfigure with override
go

DJ

[B D Jensen]

Hi!
You should not try to update sys tables!
Use the TSQL statements or SSMS-GUI...

/Bjorn