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