By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,773 Members | 1,779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,773 IT Pros & Developers. It's quick & easy.

Lost Full Text catalog that won't delete!

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.