July 1, 2003 at 7:23 am
Whats the best way of moving a file from one filegroup to another? any help will be greatly appreciated.Thanks
July 1, 2003 at 9:51 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy