Prev: connection to sql server 2005 problem
Next: Couldnt Take Script using SMO columns binded default values
From: Rob MacFadyen on 3 Jul 2008 20:16
Hi,

On the same instance of SQL 2005/SP2 (win2003 sp2) if I backup a database
with a full text catalog and then restore the database (on the same instance)
I get the following warning:
Warning: Wordbreaker, filter, or protocol handler used by catalog '%ls' does
not exist on this instance. Use sp_help_fulltext_catalog_components and
sp_help_fulltext_system_components check for mismatching components. Rebuild
catalog is recommended.

The database is "plain jane"... using the default collation of
Latin1_General_CI_AI.

The sp_help_fulltext_catalog_components and
sp_help_fulltext_system_components don't appear to show anything mismatched.
What should I be looking at next? Is it safe to ignore the error?

With another database, I get the same error. The
sp_help_fulltext_catalog_components results does show 2 entries for
WordBreaker, and 2 for Protocol Handler. Though these use the same clsid/dll
but version's are different. 2 of these entries do not have corresponding
entries in sp_help_fulltext_system_components (version #'s don't match).

WordBreaker's versions are 12.0.6828.0 and 12.0.5626.1 (LANGWRBK.DLL, 1033,
188D6CC5-CB03-4C01-912E-47D21295D77E). Protocol Handler versions are
2005.90.3042.0 and 2005.90.1399.0 (SQLFTH90.DLL, sqlfth90.sqlfth90.1,
F159B0AF-B280-433B-A6A6-67A1032C1258). Should I be removing the older
versions? If so how?

Thanks for helping!

Regards,

Rob


From: Rob MacFadyen on 11 Jul 2008 00:21
Hi,

Anyone have any clue about this problem at all?

Thanks,

Rob
From: Denny Cherry on 11 Jul 2008 16:21
What's the text of the error that you are getting?

On Thu, 10 Jul 2008 21:21:00 -0700, Rob MacFadyen
<RobMacFadyen(a)discussions.microsoft.com> wrote:

>Hi,
>
>Anyone have any clue about this problem at all?
>
>Thanks,
>
>Rob
Denny Cherry
Senior DBA / Architect
MCSA, MCDBA, MCTS, MCITP
From: Rob MacFadyen on 11 Jul 2008 16:54
Denny,

The error is:

Warning: Wordbreaker, filter, or protocol handler used by catalog '%ls' does
not exist on this instance. Use sp_help_fulltext_catalog_components and
sp_help_fulltext_system_components check for mismatching components. Rebuild
catalog is recommended.

Note: %ls is replaced with the name of the full text catalog.

Regards,

Rob
 | 
Pages: 1
Prev: connection to sql server 2005 problem
Next: Couldnt Take Script using SMO columns binded default values