January 9, 2013 at 12:24 am
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.
January 9, 2013 at 4:59 am
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
January 9, 2013 at 7:31 am
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 - MCSomething someday:-)
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 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
January 14, 2013 at 4:18 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply