>Is there a way to reassign a FileGroup to a File?
I don't know of anything. Have you tried Google?
OK. you can manually move the data by recreating the clustered index on the other filegroup. For the non-clustered indexes, you'll have to drop and recreate them.
-Mike
>Hi!,
>Thanks for the reply,
>
>The two files I have belongs to different FileGroups, and the DBCC SHRINKFILY with EMPTYFILE option works only for files on the same FileGroup.
>
>Is there a way to reassign a FileGroup to a File?
>
>
>Thanks again in advance!.