Move Index from Primary File Group to Another File Group

Question

Post reply

Move Index from Primary File Group to Another File Group

Bhushan Kalla

Default port

Points: 1475
More actions
January 29, 2007 at 1:57 pm

#117458

Hi Everyone,

I need to move indexes from Primary File Group to another new file group. Would anyone please help me if there is a T-SQL statement to do that? I know one method that can be accomplish this task through GUI (Index Properties window in Management studio and click on storage and change the file group to the new file group you wanted).

Additional Infomration:

My database has only primary and log file groups and all data and indexes are sitting on same file group and file name. Now the disk is full and all also performance is very poor since data and indexes are on the same drive. Now I would like to move the indexes to different file that sits on different drive. I couldn't find the right option in Alter Table, Alter Database etc...to move indexes from Primary to new file group. Any help is greatly appreciated.

Thanks,

BK

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

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

dclark SSC Eights! Points: 843 More actions · Answer 1

dclark

SSC Eights!

Points: 843

January 29, 2007 at 2:18 pm

#686277

If you use Enterprise manager to make the changes, you have the option to click the script button to see the script that it would use to make the change, and you can save that script if you want to. Then just cancel making the change in Enterprise manager.