Upgraded to SQL 2012... doesn't seem to be rebuilding all full text..doing this NOW

  • I just upgraded a fairly large environment to SQL 2012....

    I chose the option to rebuild ALL the full text...

    However, it doesn't seem like it did it...I have about 500 GB of full text in each server.

    How can I check when they were last rebuilt? Also, how can I rebuild ALL for ALL user databases at once?

    Thanks... I'm doing this right now so help quick would be appreciated. thanks all!

  • A quick thought, build an alter catalog sql string and run in each db?

    😎

    SELECT

    CONCAT('ALTER FULLTEXT CATALOG ',FTC.name,' REBUILD;')

    FROM sys.fulltext_catalogs FTC

  • I can do that, but isn't there a way to tell in general which ones are populating? Shouldn't it have populated based on my option in the upgrade? I have 150 databases on each server... ugh. We don't NEED them to be rebuilt... but still.

  • A hunch, if the catalogs are set to "do not track changes", I believe the upgrade will not rebuild them.

    Whether you HAVE to, I don't know, last time I upgraded 2008 to 2012, I opted to do the rebuild manually.

    😎

  • Oddly enough, the all say they were last populated right after the upgrade ...and are mostly idle (except I've repopulated a couple large ones...)... Track changes it set to automatic.

    I'm stumped and mildly annoyed. This isn't a bad thing and won't cause problems, truth is, it's actually probably better as the software that uses these indexes saves the searches and they are re run.... so, if people go back into their saved search, they MAY see new results which isn't wanted (but I warned them, and they were OK after reviewing the changes to full text)....

    Not the end of the world, but I'm still curious... maybe tomorrow I'll get some responses.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply