I don't know of anyway to do this using the RESTORE command but after you restore all of the files, you can probably use DBCC SHRINKFILE() with the EMPTYFILE option to force SQL Server to move all of the data off of the extra file. Then you should be able to remove the file.

-Mike

>Hi!
>
>I've created a database with multiple files (2 mdf's) and therefore multiple log files (2 ldf's).
>
>I need to restore that database into one file ( 1 mdf and 1 ldf ).
>
>How can I achieve this?
>
>Thanks in advance!