Adding a New Filegroup to Existing Partition?
Posted on 2010-04-02
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?