FT Catalog becomes corrupt after server crashes during incrmental pop.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zoidberg - 30 Jan 2007 17:02 GMT

Has anybody every expirenced this, and if so, is there any way to
repair the index as opposed to Rebuilding the index and then starting
a full population on it. My table that's full-text indexed has over 12
million records in it, and it takes 5+ days to do a full population.

Any ideas/advice would be greatly appreciated.

Regards,
Robert Steel

Reply to this Message

Hilary Cotter - 30 Jan 2007 21:12 GMT

I've run across it. I have not being able to find a way to do this. in our
case the problem was due to faulty disks IIRC.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Has anybody every expirenced this, and if so, is there any way to
> repair the index as opposed to Rebuilding the index and then starting
[quoted text clipped - 5 lines]
> Regards,
> Robert Steel

Reply to this Message