Hi all,
I started digging into the fulltext catalogs on a 2008 and 2008R2 system and trying to understand the basics.
Is it true that the catalogs are - other than up to sql 2005 - stored in the filegroup where the table resides?
My idea is to move the catalogs over to a faster and bigger storage for performance reason.
I found no hints so far on which commands to use to move the catalogs over.
If my assumption would be true this would mean the following:
1. create a new filegroup
2. disable or delete the active full text indices
3. move the whole table to the new filegroup
4. recreate the full text indices
5. repopulate them
this is very time consuming on a couple of tables, each containing 3+ million rows.
so my questions are:
Is my assumption correct?
Has anyone done that before and has some experience?
Is there a script or even snipplet available from anyone who did that before to automate it?
Thanks already for any answer!
/usenet