Moving file from filegroup to another

• pavan-178969

  Mr or Mrs. 500

  Points: 512

  More actions

  August 18, 2005 at 10:39 am

  #152515

  Hi,

  I have 2 problems they are seperate from each other )

  1. how to move a data from one file in a file group to another file on anothere filegroup.

  2. I executed dbcc shrinkfile (<filename>,emptyfile), it shot out successful messge then i tried to drop that file using alter database command but it gives error the file is not empty.

  PLz reply asap, it's critical

   

• peterhe

  SSChampion

  Points: 11469

  More actions

  August 19, 2005 at 7:13 am

  #583500

  check out this article: http://www.sqlservercentral.com/columnists/cmiller/gettingridofexcessfilesandfilegroups.asp