Thanks in advance for all help.
We are building a new SQL Server 2008 prod box. I need to take the data from the current prod box and restore on the new one.
I would like to get the databases set up better so we can have the database files over multiple volumes but creating multi volume file groups. But i beleive when i restore it will only allow me to restore the 1 mdf from the backup to 1 mdf on the restore side.
What is the suggestions to do this? Is there one?
Thanks again Rich