Posted on: 6/24/2013 5:45:49 PM | Views : 1362

I am having problem restoring a SQL Server 2013 database backup to a LocalDb instance.  Here's what I do:
Create a full backup of the database, overwriting all existing backup sets (I simply use the backup GUI for this), on the production serverCopy the backup file from the production server to my local development systemCreate a new LocalDb instance, share it, and start itConnect to the LocalDb instance using SQL Server Management Studio,Attempt to restore the database using the restore GUI, explicitly defining the location of the data and log files and selecting WITH REPLACE and RESTORE RECOVERY. The database restore operation starts and after a little while fails with the error:
The logical daabase file '<logical log file>' cannot be found. Specify the full path for the file.
I've looked at the file list in the backup and everything appears to be in order.
I've viewed other threa ...

Go to the complete details ...