My primary filegroup was growing too big so i decided to create a new filegroup and transfer most of the tables over there. But, the primary filegroup was still at 50 GB of size in a RAID 1 container, so I decided to create a new file for PRIMARY in a RAID 10 container, and I proceeded to execute: DBCC SHRINKFILE (1, EMPTYFILE) RTFM says it will empty the file in order to drop it from the database. Sure it did transfer the tables from the 50 GB file to the new file. So I proceeded to drop old 50 GB file: ALTER DATABASE [DB_NAME] REMOVE FILE [PRIMARY_FILE_1] I get this error: Server: Msg 5020, Level 16, State 1, Line 1 The primary data or log file cannot be removed from a database. But that does not make sense because the PRIMARY filegroup is still in place with now 2 files. I just want to keep the new one and drop the old one. I cannot even shrink it. Any clues?