• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

Cannot Rebuid Full-text catalog

Hi All,
Our database had some issues which we narrowed down to a problem with the full-text catalog.

I have run the following query:
Use DBName
EXEC sp_fulltext_database 'enable'  
and It says 'Query Executed Successfully'

However, when I select the Full text catalog and right click on it - the option REBUILD is disabled.
Please assist - how do I rebuild this catalog.

  • 2
1 Solution
godwineffiongAuthor Commented:

We decided to restart the server and now the full-text catalog is blank.
Click on Full-text catalog and expand (+) returns nothing.
Eugene ZCommented:
you need to create FTS catalog
see example:
Quick steps: Using the Full-Text Wizard

Getting Started with Full-Text Search
godwineffiongAuthor Commented:
Thank you. The articles helped me greatly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now