HI ,

Using the DBBC shinkfile with the EMPTYFILE will mark the file to no longer accept data. Then using the alter database to remove the file will get remove it .

USE My_Database

GO

DBCC SHRINKFILE (N'SecondFile' , EMPTYFILE)

GO

ALTER DATABASE My_Database REMOVE FILE SecondFile

cheers

Greg