DB Restore from multiple files

Hi,
I've got a pretty large database that i normally backup to 6 files and
restore it to another database. I've only done this through enterprise
manager so it's just point and click. But i was wondering if anyone knew wha
t
the command line version of this would be? Would you use "stripe" ? Trying t
o
script the backup and restore part. Any help would be greatly appreciated.
-FSHello,
See RESTORE DATABASE command in books online. Use the below sample.
RESTORE DATABASE DBNAME FROM disk = 'C:\MSSQL\BACKUP\DBA_db_BKUP_BAK1.BAK',
disk = 'D:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK2.BAK',disk =
'E:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK3.BAK', Stats=1
Thanks
Hari
"FS" <FS@.discussions.microsoft.com> wrote in message
news:28DD5BE8-5B09-4262-81FE-B3C6CA5FB636@.microsoft.com...
> Hi,
> I've got a pretty large database that i normally backup to 6 files and
> restore it to another database. I've only done this through enterprise
> manager so it's just point and click. But i was wondering if anyone knew
> what
> the command line version of this would be? Would you use "stripe" ? Trying
> to
> script the backup and restore part. Any help would be greatly appreciated.
> -FS