How can I delete a file of the primary filegroup (SQL Server)

Question

I have a database with a lot of tables and I created a new file in the primary filegroup, I haven't inserted any new data yet but when I try to delete this new file, I get this error

The File ‘newfile’ Cannot be Removed Because it is Not Empty

How can I delete this file?

https://www.sqlservercentral.com/Forums/Topic652585-146-1.aspx — Mitch Wheat, Apr 16 '18 at 03:16

score 1 · Accepted Answer · answered Apr 17 '18 at 16:03

ok, the solution was as Mitch Wheat indicated in the link that he showed. I had to empty the file using:

DBCC SHRINKFILE(newfile,EMPTYFILE)

then it can be eliminated using:

ALTER DATABASE DBNAME REMOVE FILE newfile

How can I delete a file of the primary filegroup (SQL Server)

1 Answers1