rightfield
SSCrazy
Points: 2418
More actions
April 2, 2008 at 7:22 am
#184674
Hi experts,
I have 20 relatively small tables in a database that were assigned to the PRIMARY file group and I would like to move them to a different file group. Is this possible? How? Thank you.
Warm regards,
Steve Jones - SSC Editor
SSC Guru
Points: 728159
April 2, 2008 at 8:34 am
#797279
Rebuild the clustered index on the new filegroup and that will move the table.
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply