data-konzept

'You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve decided that you don’t actually need some of those additional files and want to get rid of them. Here are some steps you can follow.

Assume there are 5 files and they are numbered 1-5. We want to get rid of 2-5 and keep just file 1.'...

http://www.sqlservercentral.com/blogs/sqlstudies/2016/05/02/remove-files-from-a-filegroup/