Geeks With Blogs
SharePoint & SQL Thoughts

When creating your partition schemes you get the following error

The associated partition function MyPartitionScheme generates more partitions than there are file groups mentioned in the scheme ' MyPartitionScheme'.

If you look at the error closely, its yelling that SQL Server has more than one File Group and in your savvy Scheme creation you decided to shove everything in one filegroup hence the yelling.

 You can resolve it by either defining your file groups in the scheme see snippet below or you if you are still convinced that you only need one file group then define your syntax with ALL see snippet below.

 Multi file groups – ofcourse they have to exist.

CREATE PARTITION SCHEME [myPartitionScheme]
AS
PARTITION myDataPartition
TO
(test1fg, test2fg, test3fg, test4fg);

Syntax with ALL

CREATE PARTITION SCHEME [myPartitionScheme] 

AS PARTITION myDataPartition

ALL  TO (Archived)
GO
Posted on Wednesday, May 1, 2013 3:44 PM | Back to top


Comments on this post: The associated partition function MyPartitionScheme generates more partitions than there are file groups

Comments are closed.
Comments have been closed on this topic.
Copyright © Leonard Mwangi | Powered by: GeeksWithBlogs.net