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!.