all,

The new solution has been discovered.

Actually we can move data between files into same filegroup.

we need to create the new file in the same file group and then restrict the autogrowth to the other files except one that you want to move the data. Or we can do the same with restricting autogrowth of the existing files except that you want to move data.

Once this step finished.....you need to shrinkfile with an emptyfile option which will move the data from one file to another file and make it empty...after that you can keep that file or delete it and enable the autogrowth of the other files...

Regards,

Mitul.