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 |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2004-08-31 : 05:58:06
|
| Is it possible to move a FILE from one FILEGROUP to another?As it is, I've just deleted and re-created, but that is a little more extreme than I would like.-------Moo. :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-31 : 12:54:53
|
| Move a file from one filegroup to another? What do you mean? How are files part of filegroups? A filegroup is a file.Tara |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-08-31 : 14:03:43
|
| Um, Tara? Someone hijacked your keyboard!Filegroups are logical units that extend beyond a single file. Filegroups, as the name suggests, contain multiple files.So far as I know, there is no way to move a file between filegroups once it has been created...data is "striped" across the files in a filegroup so just isolating one and separating it would be pretty hard.Why do you need to do this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-31 : 14:12:19
|
| Dangit, I was thinking of something else. Sorry for the confusion.Tara |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-08-31 : 14:21:50
|
| ALTER DATABASE REMOVE FILE xxxALTER DATABASE ADD FILE xxx TO FILEGROUPIs all I can come up with.rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-02 : 05:56:50
|
| How pesky. Though, I suppose, understandable.-------Moo. :) |
|
|
|
|
|
|
Move file between filegroups?