How to move table partitions to different file groups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to move table partitions to different...

How to move table partitions to different file groups

Rate Topic

Display Mode

Topic Options

Author

Message

SQListic

Posted Wednesday, January 09, 2013 12:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:42 PM
Points: 193, Visits: 773

Hi Experts,

Can you please help me in movin my 4 table partitions of a table to 4 different file groups. Right now all the partitions are on Primary file group.

Post #1404569

peterdru401

Posted Wednesday, January 09, 2013 4:59 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:34 AM
Points: 23, Visits: 128

First you should check few things before moving a table

1. You cannot change the data type of the partitioning column once the table is partitioned.
2. You can move an index to a partition scheme after it has been created.
3. You cannot use the SWITCH option of ALTER TABLE statement on replicated tables.

Have a look at quite similar discussion ..

http://dba.stackexchange.com/questions/16708/moving-large-number-of-tables-to-different-filegroups

Either you can go for a third party tool for moving table partitions to different file group like Lepide SQL Storage Manager

Post #1404690

Want a cool Sig

Posted Wednesday, January 09, 2013 7:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 26, 2013 2:58 PM
Points: 221, Visits: 452

I think the easiest would be to create a new partition function and move the table to that new function. I'm assuming you want to move the whole table which has 4 partitions.

---------------------------------------------------------------
Mike Hahn - Future MCM 2025 Smile

Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar Hehe

I want a personal webpage Cool

I want to win the lotto BigGrin

I want a gf like Tiffa w00t

Post #1404784

itsmemegamind

Posted Monday, January 14, 2013 4:18 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 04, 2013 12:43 AM
Points: 10, Visits: 45

The above all mentioned operation can also be performed easily by any sql management software in a very few time
it save lot of time of DBA

http://www.sqlservermanagement.net/

Post #1406652

« Prev Topic | Next Topic »

Permissions