Post reply

data file distribution on file group

  • June 13, 2011 at 12:46 am

    #241275

    Can any body help on scenario...................

    what is the command to create table in an .NDF file. Suppose i have one .MDF one .ldf and a newly cretated .ndf file .All are in default flle group.

  • June 13, 2011 at 1:38 am

    #1337601

    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

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

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

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