asked on

Adding a New Filegroup to Existing Partition?

Hi, I recently asked a question about how to create a table partition for a complex data situation that we have. I think I have figured out the best way to implement this however, I have a question about how to handle new data.

IE: We have a table partitioned into years... 1995, 1996, 1997, etc... up to current year 2010.

So, I create a bunch of filegroups and create my partition scheme based on the years that currently exist... 1995-2010.

2010 rolls along and I just keep inserting new records into the partitioned table for 2010...

Well, what happens when 2011 comes? I looked at alter partition function but it only allowed for splitting and merging exisiting partitions into new ones...not just creating a new one entirely.

So, how does one handle adding a "new" set of ranges to an existing partition... do you have to create a new one entirely and then move the data over?

MohammedU

Check for ALTER PARTITION SCHEMA
Adds a filegroup to a partition scheme or alters the designation of the NEXT USED filegroup for the partition scheme.
http://technet.microsoft.com/en-us/library/ms190347.aspx

Roxanne25

ASKER

Yes I looked at alter partition schema... it only lets you add a partition for an existing file group and as I mentioned the alter partition statement only lets you merge or split filegroups....

ASKER CERTIFIED SOLUTION

Colin Brazier

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roxanne25

ASKER

Ah awsome! That is what I needed...then I can split the ranges around to make sure the right years are in the right places... coolies. Ty. :)