Hi everyone, I have restored in a new istance of SQL
(no upgrade) a backup of a database of another istance.

Ok... but my full-text has stopped to work!

Any full-text query working, but if I try to rebuild
a catalog that already exists I get the error:

error 7608: An unknown full-text failure (8007007e)
occured in function CreateCatalog on full- text
catalog 'somename'

Now, i have installed the latest service pack (3a).
Same problem, if I try to activate the full-text function
(or create a new empty catalog):

EXECUTE sp_fullext_database @action = 'enable'

I get the error:

error 7608: An unknown full-text failure (8007007e)
occured in function EnumCatalogs on full-text catalog ".

My SQL is version 2000 (now SP3a -8.00.760) on win2000 SP4.

Thanks to every one.

Francesco

*** Sent via Developersdex http://www.developersdex.com ***

Google doesn't help too much, but there is a discussion in dbforums about
uninstalling Full text searching.

My first suggestion is to check the Microsoft Search service. Stop it and
start it. Look in the application log for any possible errors. Make sure
there is enough space on the disk where it is running. You may want to
reinstall the Win 2k sp 4.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]

Francesco,
Andy, while re-installing the FTS components has resolved this error
in past postings, for this Francesco's issue, it might be overkill at
this time. Primarly, he is getting this error after restoring a SQL
Server 2000 FT-enabled database from a backup that possibly was from a
time period when the database was not FT-enabled. Francesco, could you
confirm this?

If the backup was from a time period when the database was not
FT-enabled or if the FT Catalog did not exist at that time, then the
error is understandable, if somewhat vauge. As the database backup
does not contain the FT Catalog, nor the MSSearch required registry
key, a better approch would be to use the procedures in KB article
Q240867 "INF: How to Move, Copy & Backup Full-Text Catalog Folders &
Files" at http://support.microsoft.com/default.aspx?scid=kb;en-us;240867&Product=sql2k

If you have Regitry hive backup, you can restore the HKLM\Search hive,
if not, you may also be able to re-construct the entries by using
procedures in Q240867 and if not, then re-installing the FTS
components is still an option.

Regards,
John



[quoted text, click to view]