?
Solved

Cannot Rebuid Full-text catalog

Posted on 2008-06-16
3
Medium Priority
?
501 Views
Last Modified: 2008-06-20
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.

Thanks,
0
Comment
Question by:godwineffiong
  • 2
3 Comments
 

Author Comment

by:godwineffiong
ID: 21796467
UPDATE:

We decided to restart the server and now the full-text catalog is blank.
Click on Full-text catalog and expand (+) returns nothing.
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 21796564
you need to create FTS catalog
see example:
Quick steps: Using the Full-Text Wizard
http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1161791,00.html

Getting Started with Full-Text Search
http://technet.microsoft.com/en-us/library/ms142497.aspx
0
 

Author Comment

by:godwineffiong
ID: 21834810
Thank you. The articles helped me greatly.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
Steps to fix “Unable to mount database. (hr=0x80004005, ec=1108)”.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question