Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdkottman
Starting Member
7 Posts |
 Posted - 2007-07-05 : 14:40:03
|
| Does anyone know how to move tables between filegroups in 2005?Cogito ergo spam -- I'm pink therefore I'm Spam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-05 : 15:05:57
|
| Create the table on the other filegroup using a new name. Move your constraints and indexes to this new table, copy the data over, drop the original table, then rename the new table to the name your application is expecting.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-07 : 14:50:20
|
| in 2000 you can change the filegroup on design table, properties --> choose filegroup, try it;-)Need an SQLDB consultant?check www.veeningsengineering.nl |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-07 : 21:44:47
|
| Or recreate clustered index on new file group, always backup the db first of course. |
|
|
|
|
|
|
Moving tables between filegroups