DB restore error

Hi
I'm passing the following SQL statement to my SQLServer:
RESTORE DATABASE myDB FROM DISK 'd:\mssql\backup2\myDB.bak' WITH MOVE 'myDB'
TO 'd:\mssql\data\myDB.mdf', MOVE 'myDB_log' TO
'd:\mssql\data\myDB_log.ldf'
However, when I run this, I get the following error:
Server: Msg 3234, Level 16, State2, Line 1
Logical file 'myDB' is not part of database 'myDB'. Use RESTORE
FILELISTONLY to list the logical file names.
I've had a look in the help and I'm not really any the wiser. Can someone
explain to me what is occuring here?
Thanks
GriffOkay - understood it now...the "data" was called "myDB_Data" and not "myDB".
Griff|||Hi
Looks like you specify incorrect path to your log file or you don't have
the path created on hard disk.
Did you run FILELISTONLY as it is suggested ?
"GriffithsJ" <GriffithsJ_520@.hotmail.com> wrote in message
news:exzIowrzDHA.1576@.TK2MSFTNGP11.phx.gbl...
> Hi
> I'm passing the following SQL statement to my SQLServer:
> RESTORE DATABASE myDB FROM DISK 'd:\mssql\backup2\myDB.bak' WITH MOVE
'myDB'
> TO 'd:\mssql\data\myDB.mdf', MOVE 'myDB_log' TO
> 'd:\mssql\data\myDB_log.ldf'
> However, when I run this, I get the following error:
> Server: Msg 3234, Level 16, State2, Line 1
> Logical file 'myDB' is not part of database 'myDB'. Use RESTORE
> FILELISTONLY to list the logical file names.
> I've had a look in the help and I'm not really any the wiser. Can someone
> explain to me what is occuring here?
> Thanks
> Griff
>