472,106 Members | 1,378 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,106 software developers and data experts.

Lost Full Text catalog that won't delete!

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?
Mar 5 '08 #1
3 2492
Hi!
what's your error message?

I had something similar, where the error message told me to backup log
file...
Greetings
Bjorn
Mar 6 '08 #2
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_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
Mar 6 '08 #3
Hi!
You should not try to update sys tables!
Use the TSQL statements or SSMS-GUI...

/Bjorn
Mar 6 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Adisorn Ratanakovit | last post: by
reply views Thread by Denise | last post: by
6 posts views Thread by spied | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.