Post reply

Index on seperate datafile

  • September 18, 2009 at 2:57 am

    #214580

    I would like to have all indexes on a separate datafile but without adding another file group (use Primary). Is this possible and what script will I use?

    Thanks

  • September 18, 2009 at 3:07 am

    #1055431

    I don't think you can - you can only specify the filegroup and then assign this another data file.

  • September 18, 2009 at 3:10 am

    #1055434

    Electrix (9/18/2009)

    I would like to have all indexes on a separate datafile but without adding another file group (use Primary). Is this possible and what script will I use?

    Thanks

    As far as I Know you cannot.

    this is the clause from BOL for create index

    ON filegroup_name

    Creates the specified index on the specified filegroup. If no location is specified and the table or view is not partitioned, the index uses the same filegroup as the underlying table or view. The filegroup must already exist.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • September 18, 2009 at 3:21 am

    #1055442

    That's what I found as well. The only way is a new file with it's own filegroup and specify the filegroup when creating the index.

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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