Yak Posting Veteran
Posted - 05/23/2010 : 03:51:51
I have create database partition, perform switching, partition merging , and all of those works fine. The next thing I wanted is split the partition.
At first, it gives errors, saying "The associated partition function 'function_name' generates more partitions than there are file groups mentioned in the scheme 'Scheme_name'".
Then I add another file group in order to split the partition. With the following code.
Alter database [DB_Name] add FILEGROUP [Filegroup_Name]
alter database [DB_Name]
(NAME = 'Filegroup_Name',
SIZE = 5MB,
TO FILEGROUP [Filegroup_Name]
After the above step, I able to split the partition. Later, I perform same steps again, switch partition, merge partition. As of now, things were OK. Then I need another split here. But, I hit the same error again, I know by creating new file group, the problem should be solved. But, I do not want to create new file group, cos by doing, it seems like never ending story of new file group creation.
Is there any other way I can split the partition withing current file group?