filegroups

After you restore a backup, how do you assign a new
filegroup?
I have a 280 GB that uses one file group and I want the
current files to point to different filegroups. How is
this done?

Add a new filegroup to the database then you can move
table data to the new filegroup by creating/rebuilding the
clustered index.
For indexes just recreate the index.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 28th February 10:10 delbert External User Posts: 1	filegroups After you restore a backup, how do you assign a new filegroup? I have a 280 GB that uses one file group and I want the current files to point to different filegroups. How is this done?

2 28th February 10:10 nigel rivett External User Posts: 1	filegroups Add a new filegroup to the database then you can move table data to the new filegroup by creating/rebuilding the clustered index. For indexes just recreate the index.