question

adisid024 avatar image
adisid024 asked

Can i create multiple filegroups as a primary file group for sql server table partitioning?if yes how?

if i don't want to create multiple file groups in the same drive or different drive, can i create multiple file groups as a primary file group for SQL Server table Partitioning? If Yes then how?
partitioningfilegroup
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
Your question is a bit confusing! There could be only one primary file group called PRIMARY. Multiple file groups cannot be part of any other file groups. Multiple files could be part of one file group though. And you could re-assign a default file group from PRIMARY. Can you clarify you question please?
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

adisid024 avatar image adisid024 commented ·
Sorry for the confusion Denis and also thanks for your response. I got the answer of my question. Here is another question,I want to know can i Switch multiple file groups to another table(archive table) at a time?
0 Likes 0 ·
DenisT avatar image DenisT adisid024 commented ·
If I understood you correctly, then the only way I am aware of doing this is to CREATE CLUSTERED INDEX .... WITH (DROP_EXISTING = ON) ON [Name_New_FG]; That will move the table from one file group to another.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.