# Sql Server Restore Database Action failing

**URL:** https://www.finalbuilder.com/forums/t/sql-server-restore-database-action-failing/1405
**Category:** Discussion
**Created:** [December 15, 2009, 10:32am UTC](https://www.finalbuilder.com/forums/t/sql-server-restore-database-action-failing/1405 "2009-12-15T10:32:44Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![pkellner](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/pkellner/32/94_2.png) [@pkellner](https://www.finalbuilder.com/forums/u/pkellner)
#### Post date: [December 15, 2009, 10:32am UTC](https://www.finalbuilder.com/forums/t/sql-server-restore-database-action-failing/1405/1 "2009-12-15T10:32:44Z")

</div>

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

When I run SqlServer Restore Database, I get&nbsp;

Could not restore backup: Incorrect syntax near '3'

No idea what this means. &nbsp;What is the command being executed?

&nbsp;

What do I need for this to work? I"m using sqlserver 2008 on win7 ultimate

---

<div class="post-metadata">

### Author: ![paulsamways](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/p/e8c25b/32.png) [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [December 16, 2009, 8:34am UTC](https://www.finalbuilder.com/forums/t/sql-server-restore-database-action-failing/1405/2 "2009-12-16T08:34:55Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [February 8, 2010, 6:04am UTC](https://www.finalbuilder.com/forums/t/sql-server-restore-database-action-failing/1405/3 "2010-02-08T06:04:19Z")

</div>

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