data file distribution on file group

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 1

you cant create objects on a particular File,you can create objects in a different File groups and then File groups have multiple files

CREATE TABLE [dbo].[TEST]([Id] [int] NOT NULL) ON [PRIMARY] ---- default FG

OR

CREATE TABLE [dbo].[TEST]([Id] [int] NOT NULL) ON [MYFG] ------ User FG

If you want to create objects in a particular file then create File Group first and then add 1 file in that FG then create object on this FG

My Blog
www.aureus-salah.com