February 1, 2013 at 3:49 am
HI,
Can any one suggest me how to place fulltext index into diffrent filegroup which i created in diffrent drive.
February 1, 2013 at 4:13 am
Use the "select index filegroup" option of the wizard when creating the index.
February 1, 2013 at 4:51 am
Thank you anthony.green,
Fulltext index already created the in developing server and want to implement in production server with changing the filegroup.
How do i change my full text file group.
February 1, 2013 at 4:52 am
When you create the full text index, use the option I detailed to tell it where to put it.
February 1, 2013 at 5:03 am
Thank you
I need to change my filegroup which is already created with primary file group.
Should i fulltext and create new ?
February 1, 2013 at 5:06 am
If the FTC / FTI is already created, then the only way I know of to move it to a different file group is drop and recreate.
February 1, 2013 at 5:32 am
ratheesharc (2/1/2013)
Thank you anthony.green,Fulltext index already created the in developing server and want to implement in production server with changing the filegroup.
How do i change my full text file group.
On the production system create the new filegroup and create a new file inside the filegroup.
Create a new Fulltext catalog.
To create the index use the following syntax
CREATE FULLTEXT INDEX on tablename(columnname, columnname,n,n,n)
KEY INDEX the_unique_index_name_you_are_using
ON (fulltextCatalogname, FILEGROUP filegroupname)
WITH options here
This is all detailed in Books Online 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2013 at 6:03 am
Thank you very much for you reply....
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply