Restore Database On VMWare

Hi,

Problem:

I've been pulling my hair out, trying to restore a database on a virtual machine (Vista Home Basic), hosted via VMWare on a WinXP Pro sp2 box.

Executing a command in a cmd file:

EXECUTE('RESTORE DATABASE [' + @Database + '] FROM DISK = ''' + @BackUpPath + '.bak''');


Produces this error:


Log Name: Application
Source: MSSQL$AB_1
Date: 20/01/2008 9:27:34 AM
Event ID: 18204
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: appsbook
Description:
BackupDiskFile:penMedia: Backup device 'C:Program FilesAppNameDbBAckUp.bak' failed to open. Operating system error 2(error not found).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$AB_1" />
<EventID Qualifiers="49152">18204</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2008-01-19T22:27:34.000Z" />
<EventRecordID>2420</EventRecordID>
<Channel>Application</Channel>
<Computer>appsbook</Computer>
<Security />
</System>
<EventData>
<Data>BackupDiskFile:penMedia</Data>
<Data>C:Program FilesAppNameDBBAckUp.bak</Data>
<Data>open</Data>
<Data>2(error not found)</Data>
<Binary>1C470000100000000E000000410050005000530042004F004F004B005C00410042005F003100000000000000</Binary>
</EventData>
</Event>