Remove (merge) SQL Servers’ database secondary data file

• Back up the database
• Execute

  use database_name dbcc shrinkfile(‘ndf_file_name’, EMPTYFILE)

• Execute

  alter database database_name remove file ‘logical_ndf_file_name’