|
ryanlcs
Yak Posting Veteran
61 Posts |
 Posted - 05/23/2010 : 03:51:51
|
Hi
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]
go
alter database [DB_Name]
ADD FILE
(NAME = 'Filegroup_Name',
FILENAME =
'Physical_File_Name',
SIZE = 5MB,
MAXSIZE=500,
FILEGROWTH=1 )
TO FILEGROUP [Filegroup_Name]
Go
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?
Please advice.
Thanks. |
|
Splitting Partition
