Post reply

How to assign a file to another filegroup ?

  • October 1, 2010 at 3:41 pm

    #387925

    I need to move a file to another filegroup. I tried

    alter database Dev3_F

    modify file FILE_TEST_01

    to filegroup [primary]

    go

    alter database Dev3_F

    modify file

    (name = 'FILE_TEST_01')

    to filegroup [primary]

    go

    In either case was syntax error. B.O.L. does not have examples for this.

  • October 1, 2010 at 3:49 pm

    #1230590

    You don't move files between filegroups.

    You move tables and indexes to a different filegroup - which will eventually lower the space requirement for the file in the filegroup from which you are trying to move.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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