SQl 2008 and 2008R2 fulltext catalogs and their locations

• usenet

  SSC Eights!

  Points: 809

  More actions

  January 12, 2011 at 5:47 am

  #230031

  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

• usenet

  SSC Eights!

  Points: 809

  More actions

  January 12, 2011 at 5:50 am

  #1272310

  sorry, posted to the wrong forum. could an admin please remove this thread?

  I now posted to the correct forum

  Thanks

  /usenet