May 16, 2014 at 11:12 pm
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!
May 16, 2014 at 11:30 pm
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
May 16, 2014 at 11:37 pm
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.
May 16, 2014 at 11:48 pm
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.
😎
May 16, 2014 at 11:54 pm
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