DBCC SHRINKFILE

DBCC SHRINKFILE

    ( { file_name | file_id }

        { [ , target_size ]

            | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]

        }

    )

EMPTYFILE

Migrates all data from the specified file to other files in the same filegroup. Microsoft® SQL Server™ no longer allows data to be placed on the file used with the EMPTYFILE option. This option allows the file to be dropped using the ALTER DATABASE statement.

-->Shrink the first file delete it using Alter Database, shrink the second file delete it and so on.