Posted on: 11/20/2012 10:01:30 AM | Views : 613

I'm trying to restore a 3rd party database dump using command line (sqlcmd) and localdb.
RESTORE DATABASE mydb   FROM DISK = 'g:\databases\DATADUMP201208080939.bak'    WITH      REPLACE,     RECOVERY,     MOVE 'ebs_DATADUMP' TO 'g:\databases\mydb.mdf',      MOVE 'ebs_DATADUMP_log' TO 'g:\databases\mydb.ldf',      STATS = 5  GO Unfortunately running this command via: sqlcmd.exe -S (localdb)\v11.0 -i script.sql results in the following output (only showing the relevant parts):
Processed 57144 pages for database 'mydb' , file 'ebs_DATADUMP' on file 1.Processed 2 pages for database 'mydb' , file 'ebs_DATADUMP_log' on file 1.The logical database file 'ebs_DATADUMP_log' cannot be found. Specify the full path for the file. Any idea what is going wrong here, since the specified log ...

Go to the complete details ...