Friday, March 30, 2012

Immedeite Help Required! - Fulltext indexing

Hello All,
When I restore a backup on a different Server, It automatically creartes the
records in sysfulltextcatalogs which refers the Catelogue path of old
database.
How to come out of this Proble?
If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured.
" Full-text catalog '' has been lost. Use sp_fulltext_catalog to
rebuild and to repopulate this full-text catalog. "
Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?
Warm Regards
Sahian
Hi
This may help:
http://support.microsoft.com/default...b;en-us;240867
John
"Sathian" wrote:

> Hello All,
> When I restore a backup on a different Server, It automatically creartes the
> records in sysfulltextcatalogs which refers the Catelogue path of old
> database.
> How to come out of this Proble?
> If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured.
> " Full-text catalog '' has been lost. Use sp_fulltext_catalog to
> rebuild and to repopulate this full-text catalog. "
> Is there a way that we can remove the old catelogue references and re-create
> and populate the Catelogues?
> Warm Regards
> Sahian
>
>
|||John,
While that KB article talks about moving or copying FT Catalogs it does not
directly address the issue that Sathian is encountering relative to the
"Full-text Catalog has been lost" (due to deleting the entry in
sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
proc to 'clean up' or remove any FT Catalogs that are referenced in
sysfulltextcatalog, but not actually present on the server or in the
registry keys:
sp_fulltext_service 'Clean_Up'
This should "clean up" the registry keys and allow you to proceed. See
http://msdn.microsoft.com/library/de...ullad_2gtv.asp
for more details.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...[vbcol=seagreen]
> Hi
> This may help:
> http://support.microsoft.com/default...b;en-us;240867
> John
> "Sathian" wrote:
the[vbcol=seagreen]
the[vbcol=seagreen]
re-create[vbcol=seagreen]
|||Hi John
The removal of the record was by the OP,
"If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured."
He required:
"Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?"
If he follows the article he can transfer the Full Text indexing correctly.
John
"John Kane" wrote:

> John,
> While that KB article talks about moving or copying FT Catalogs it does not
> directly address the issue that Sathian is encountering relative to the
> "Full-text Catalog has been lost" (due to deleting the entry in
> sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
> proc to 'clean up' or remove any FT Catalogs that are referenced in
> sysfulltextcatalog, but not actually present on the server or in the
> registry keys:
> sp_fulltext_service 'Clean_Up'
> This should "clean up" the registry keys and allow you to proceed. See
> http://msdn.microsoft.com/library/de...ullad_2gtv.asp
> for more details.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...
> the
> the
> re-create
>
>
|||Hi John,
True. My only point is that the OP should not be manually removing records
from a system table as it is generally not recommended by Microsoft or by
MVP's to manually delete rows from any systems tables... However, the
"clean_up" parameter of sp_fulltext_service does - "Remove from the file
system all full-text catalogs that no longer have meta data for them in SQL
Server by executing this stored procedure". Note, the meta data includes the
entries in sysfulltextcatalogs as well as the FT Catalog registry keys that
are maintained by the MSSearch service.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A2BA13CF-D2AE-4557-AE46-C3D10D2CD188@.microsoft.com...
> Hi John
> The removal of the record was by the OP,
> "If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured."
> He required:
> "Is there a way that we can remove the old catelogue references and
re-create
> and populate the Catelogues?"
> If he follows the article he can transfer the Full Text indexing
correctly.[vbcol=seagreen]
> John
> "John Kane" wrote:
not[vbcol=seagreen]
stored[vbcol=seagreen]
http://msdn.microsoft.com/library/de...ullad_2gtv.asp[vbcol=seagreen]
creartes[vbcol=seagreen]
old[vbcol=seagreen]
enabling[vbcol=seagreen]
sp_fulltext_catalog to[vbcol=seagreen]

No comments:

Post a Comment