Via google translate:
Hello dear, I tell them the problem I have, I have a database in which they separated in mdf, NDF and LDF files. The NDF which different filegroup created in the Primary.
Now what I want is to eliminate all ndf files and filegroup of this one would be left form of the traditional way with the mdf and ldf, but to eliminate them gives me an error of space which is not and managed to overcome and neither can eliminate the NDF since It tells me that the file is unique in the group nose if someone already has occurred
You'll need to move any tables or indexes that are in the secondary filegroup to primary. then you'll be able to drop the file and then the filegroup. Something like
via google
Tendrá que mover las tablas o índices que se encuentran en el grupo de archivos secundaria a primaria. entonces usted será capaz de soltar el archivo y luego el grupo de archivos. Algo como:
CREATE INDEX <index name and full definition>
WITH (DROP_EXISTING = ON)
ON [PRIMARY]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability