This are the same database, but previous database creator created the databas using more than 1 file, the files are in the same file group, so they are seating at the drive with 1 mdf, and many ndf, but they are one logical database with many phyical files in 1 file group.
Now need to make it back to just 1 xyz.mdf file
What happened is Microsoft educated them if the database is too big, make more database files and scatter over many drives for performance, but this is not the case here.
It actually cause issue because all files are seating in one drive and hard to migrate to other server, due to many files.
I like to find a way to reverse the many database files to back to the default 1 database file mdf
This is like MS Access onl have 1 mdb file, but now cut it into 4 files, how in SQL do they have some command to bring all those database files into 1 database file.
I try to backup and restore, still restore to many database files, the structure did not changed.
I was thinking there may be some command say DBCC move database and some option in the move process convert the many database files back to 1 database file, they are in the same file group.