george sibbald (1/4/2012)
I am afraid you cannot use backup\restore to change the number of files. All you can do is change where those files are restored to (a single drive from multiple drives for instance)do you have multiple filegroups or just multiple files, or a mixture of the two?
Hi George
There is one primary filegroup.
This contains:
1 x MDF file
6 x NDF files
1 x LDF file
All these files are on the same logical disk in the mssql\data folder.
Would you know another way of achieving our aims?