I have a prod database which has too many datafiles and some secondary file(.ndf).
Can some one tell me the use of .ndf files?
If we have multiple datafiles(5) under same file group for same database, Can we make them into single using any process.
I think we can do it by taking backup of that database and restoring.
But is there any way I can get rid of all those multiple(.mdf) files and make them into single file, since it is a prod databse and I can't take it offline to drop it and restore.