June 10, 2011 at 3:22 pm
I have created partition and scheme as shown below
Create partition function platform_idPF(varchar(50))
as range left for values ('AVMselect','RealQuest','Vector')
Create partition scheme platform_idsc as partition platform_idPF
to( platformavmFG, platformrealFG, platformvectorFG) but i am getting error for creation of scheme,,the error msg is shown below
Erro msg: Msg 7707, Level 16, State 1, Line 1
The associated partition function 'platform_idPF' generates more partitions than there are file groups mentioned in the scheme 'platform_idsc'.
........
My guess is i need to create extra filegroups for range left and right.? It is require to create extra filegroups for varchar.
June 10, 2011 at 3:31 pm
Need a fourth filegroup for what's in front of AVM.
There's always the 'unbounded' group in the front.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply