Our Network Admin has setup a MS SQL 2012 server and wants the DBs setup so the database files are located on 4 different drives.
My problem here is when I try to restore a DB from a different system that only uses a single database file, it wants to bring the old file structure over with it. In the restore options, I can see the file structure it wants to use (1 database file), but I cannot change it.
Is there a way to restore the database into a new database without losing the file structure?
Thanks in advance. Richard