Post reply

Moving to new file group

  • January 3, 2005 at 1:42 am

    #102331

    Hi,

    We have created all the user objects (table,sp's) in the primary file group(is the default file group).

    Now we are planning to create two more datafiles (apps_data2,apps_data3) , a file group(filegroup_ext) and include these two files(apps_data2,apps_data3)  in this filegroup (filegroup_ext) and make this as the default file group.

    My question is, is it possible to move my existing objects in PRIMARY FILEGROUP to this newly created file goup(filegroup_ext) .

    Please help me

     

    Regards

    SKV

     

     

  • January 3, 2005 at 11:45 am

    #535645

    You can move DATA and Indexes but not other objects like sp or views.

    To move a table that has a clustered index on it simple Recreate the index using the ON part of the CREATE INDEX

    if there is no Clustered index then create one to move it

    The indexes should be located on the same FG than the data or else the backups will have to account for that

    From that point on, the new tables can be created using the ON clause on the CREATE TABLE statement

    HTH

     


    * Noel

  • January 3, 2005 at 12:03 pm

    #535646

    If you need performance in your database, then consider placing the data and indexes on different filegroups which are on different drive arrays or LUNs. It makes the backup/restore process longer, but you will receive data faster as the reads are across multiple drives.

    Another way to move a table or index is to use Enterprise Manager. (Not as efficient if there are large tables or clustered indexes involved). Choose the table and right click to find Design. Then click on the Properties icon...here you can change the filegroup the object is on.

    Michelle



    Michelle

  • January 4, 2005 at 6:30 am

    #535752

    Thanks a lot

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

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