Sql Server Restore Database Action failing

FinalBuilder Discussion
1

 I've setup all the programs in options/sqlserver to point at their true locations.

When I run SqlServer Restore Database, I get 

Could not restore backup: Incorrect syntax near '3'

No idea what this means.  What is the command being executed?
 
What do I need for this to work? I"m using sqlserver 2008 on win7 ultimate
2

Hi Peter,

What are the values used for the action’s properties? The error itself is coming from SQL Server when it attempts to execute the restore command (RESTORE DATABASE dbname FROM DISK|TAPE…).

Regards,
Paul.

3

I am having a similar problem:

I am getting the following error: Could not restore backup: Directory lookup for the file "P:\MSSQL\Data\MyData_Prod.mdf" failed with the operating system error 3(The system cannot find the path specified.)

Looking at this error, it appears that the backup has a reference to a P: drive which doesn't exist in the current machine that the DB is being restored to. Do you have a way to override this so that we can tweak where the backup should go to?

Regards,

Charles