Question: can we delete ndf file?
Answer: A file can be removed from the database only if the file is empty. Without SHRINKFILE , the implication is that the file must be the only file in a user-defined filegroup and you must first drop or move all the objects (or partitions) from the filegroup to a different file group.