Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ryanlcs
Yak Posting Veteran
62 Posts |
 Posted - 2010-05-23 : 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]goalter database [DB_Name] ADD FILE (NAME = 'Filegroup_Name', FILENAME = 'Physical_File_Name', SIZE = 5MB, MAXSIZE=500, FILEGROWTH=1 )TO FILEGROUP [Filegroup_Name]GoAfter 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