Remove (merge) SQL Servers' database secondary data file

Question

I have a database backup for which SQL Server Management Studio says that it has three files in it: an .mdf file, an .ndf file and one .ldf file. This secondary data file (the .ndf one) was created for no obvious reason, so I want to remove it altogether (without losing data, of course), preferably during while the database is being restored from the backup.

Is this at all doable?

Answer 1

Ok, found a solution.

• 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'