Moving tables to another FileGroup

Question

Moving tables to another FileGroup

Jeff W

SSCertifiable

Points: 5207
More actions
September 17, 2002 at 8:32 am

#58032

I will be moving tables on to another FileGroup. I looked at the ALTER TABLE command for an easy method and did not find one. Is there a quick and easy way to do this?
I am going to try and avoid recreating the tables if I have to. To the best of my knowledge this is the only way to do it so I am seeking others advice on the situation..
Thanks 🙂
Jeff Weisbecker

"Keep Your Stick On the Ice" ..Red Green

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

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

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

Drop your clustered index, and then re-build it on a new filegroup. If you don't have a clustered index, then create one on the new filegroup. When you create the clustered index, it will build the index, and move the data to the new filegroup.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 2

The easiest way to change the filegroup of a table is through Enterprise Manager, in the design of the table, change the filegrop by clicking the new filegroup from a drop-down list.

first you need to create the new filegroup.

Jeff W SSCertifiable Points: 5207 More actions · Answer 3

Thanks!!

I never knew I could do that through 'Design Table', but I found it 🙂

fyi-I traced the execution through profiler and found that it dropped the table and recreated it.

"Keep Your Stick On the Ice" ..Red Green