SQL Server - SQL script to restore database backup file into a new database
Putting here as the comment I made did solve the problem.

The source of the MOVE syntax is the logical name of the file, not it's old physical name.  You can get the logical name by doing a FILELISTONLY restore or by querying sys.database_files if you still have access to the source.  

MOVE &lt;logical name&gt; TO &lt;path and name of file to use&gt;


Additionally, most (all?) of the various wizards through Management Studio have an option to script the commands out for you.  This is invaluable for learning the syntax and various options.