I don't believe that this can be done. Objects may be created on a specific file group, but the dba cannot control the individual file within the file group on which the object is created.
Originally Posted by mohit_sharan
Data base file groups and associated files:
CREATE TABLE Foo (MyColumn varchar(20) NULL)
CREATE TABLE Bar (MyColumn varchar(20) NULL)
You cannot now move Data2.ndf to the SECONDARY file group. The object Foo is in the PRIMARY filegroup and may (or may not) reside partially on Data2.ndf.
Out of curiousity, what do you expect to gain from attempting this?
Have you hugged your backup today?