Moving table

  • Whats the best way of moving a file from one filegroup to another? any help will be greatly appreciated.Thanks

  • If you want to move the table to new file group use the following one

    Go to the Design mode of the table in the Enterprise manager and change the table Filegroup value to the required one.

    If you want to move the entire file to new file group, I am not sure is there any direct approach but here is a good doc to move several file groups to one which will sit to your req with few modifications

    http://www.sqlservercentral.com/columnists/cmiller/gettingridofexcessfilesandfilegroups.asp

    Shas3

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

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