Background: SQL 2005, old database has 1 filegroup (Primary) and .mdf and .ldf on same drive.
New server: created database with Primary filegroup spanning 4 drives on SAN (transaction log on separate drive).
Problem: I would like to restore the database to the new server and have the datafiles spread across the 4 files in the Primary filegroup. I cannot find a way to restore the database to multiple datafiles (maybe a result of a long weekend in Vegas...). It would be nice to be able to do the following:
RESTORE DATABASE [ABCD] FROM DISK = N'K:\Temp\ABCD.bak' WITH FILE = 1,
MOVE N'ABCD_Data' TO
N'G:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ABCD_01.mdf,
H:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ABCD_02.ndf,
I:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ABCD_03.ndf,
J:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ABCD_04.ndf',
MOVE N'ABCD_Log' TO N'K:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ABCD_log.ldf', NOUNLOAD, REPLACE, STATS = 10
Thanks in advance - Grumpy