SQLTeam.com | Weblogs | Forums

Full text catalog empties unexpectedly (0MB)

sql2008r2

#1

Hi y'all

Does anybody have an idea what might empty a full text catalog all of a sudden?
I couldn't identify any pattern yet and it seems to happen sporadically.
Of course I rebuild it but after a few days or weeks it becomes empty again.
(I'm using SQL Server 2008 R2 by the way)

Your insights would be very much appreciated


#2

To remove the full text log you just need to follow these simple steps:

1. Go to the Object Explorer > expand server > expand databases > then expand the database that contains the full-text catalog you want to remove.
2. Expand Storage, and expand Full Text Catalogs.
3. Right-click the full-text catalog that you want to remove, and then select Delete.
4. In the Delete Objects dialog box, click OK.

Please go this one hopefully it may be helpful to you. http://www.sqlservercentral.com/Forums/Topic698295-324-1.aspx


#3

Thanks Jason
Even though at first I didn't understand why you explained me how to remove the catalog, I found an idea in the article you shared.
I'll give it a try and hopefully it won't happen again


#4

4 months passed and everything is OK.
Apparently the cause was 'Shrink Database' operation, because since I stopped shrinking the DB periodically, the problem hasn't occurred.
I'm not 100% sure about that, but I decided to share this nevertheless as another good reason NOT TO SHRINK A DATABASE.