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]

Re: Lost Full Text catalog that won't delete!

Hi!
what's your error message?

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

[digitalKK]

Re: Lost Full Text catalog that won't delete!

On 6 Mar, 14:59, B D Jensen <bjorn.d.jen... @gmail.comwrote :

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_data base_name>
go
-- Record FT Catalog info. (Note: path = NULL)
select * from sysfulltextcata logs
go
UPDATE sysfulltextcata logs set path = '<new_drive_let ter:
\<new_directory >'
WHERE ftcatid = <ftcatid_of_aff ected_catalog>
go
-- Record new FT Catalog info.
select * from sysfulltextcata logs
go

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

DJ

[B D Jensen]

Re: Lost Full Text catalog that won't delete!

Hi!
You should not try to update sys tables!


Use the TSQL statements or SSMS-GUI...

/Bjorn