sql server full text index not completing

[dmeikle]

I'm trying to run a full text index from a catalog created. One one server (dev server) it executes (showing full text index in progress under status) then the status changes to idle when complete. on the live server it runs for days and never completes. only that one database - the other databases on the live server are fine.

ideas?

[Shuja Ali]

[Moved to database forum]

Looks like your live database has lot of data and is pretty huge, so creating an index would take lot of time.

[dmeikle]

well, it's exactly the same data. but indexing 4000 rows shouldn't take 3 days (before we stop the process)

[Shuja Ali]

May be you should try taking the database under single User mode and then re-indexing. Not sure what other processes/applications are accessing the database.