August 14, 2008 at 10:30 pm
Is there any easy way to move some data from 1 filegroup into another easily. I want to restore a database to another database but split the data over several disks on the dest db. The source db only uses 1 db file.
August 15, 2008 at 7:24 am
The way to move data from one filegroup to another is to rebuild clustered indexes and designate the file group you want the index in. That moves the table to the other filegroup.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 15, 2008 at 6:59 pm
Nice topic...
I would suggest you an idea.. for this...
You can achieve by partitioning the data based on specific ID.. may be primary key....
Group that data in a specific file group and transfer that particular data to the destination....
As our friend told... index on the key column grab the data and put it on the destination group.
Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:
http://venkattechnicalblog.blogspot.com/
August 21, 2008 at 7:09 am
there's a script on the internet about moving tables between filegroups. This script is able to move files even without clustered indexes (temporary adding clustered indexes)
I used this script to break my single 140GB primary file into multiple files.
see: http://education.sqlfarms.com/education/ShowPost.aspx?PostID=59
This script is also explained in SQL Server magazine, January 2008
Wilfred
The best things in life are the simple things
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply