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 ...