GilaMonster (8/29/2012)
You're not trying to add a filegroup (FG4 already exists).You're not trying to add an existing file to that new filegroup. As I already said, you cannot move files between filegroups in any way at all.
The steps are:
Shrink the file that you want to remove (Not move. Remove) with the EmptyFile option
Drop the file you have just shrunk
Add a new file to the existing filegroup FG4
Move any objects you want in the new filegroup to the new filegroup via CREATE CLUSTERED INDEX
Hi, thanks for getting back to me on this.
on the second step, when I drop the file that shrunk, wouldn't that delete all the data in that file?
on the third step, if the data is deleted that is in the file, how would i move the data?
Sorry but I'm a bit confused here.
Thanks for your patience with me on this