Database Engine service could not resolve the specified file location

Database Engine service could not resolve the specified file location

Have you encountered this error message while trying to back up or restore a sql database from or to your local instance  from/to remote location or network drive ??

The message specified here is quite clear that

  1. Either location does not exist  (I know you can see the drive folder open, just make sure path spellings you are entering into sql backup/restore wizard are correct)
  2. Current login account does not have access to it. (yea, i know you can access the remote network folder (where you want restore or back up from) in windows explorer using the same login (generally windows login and you are connected to local sql server instance using same windows login)

 

Solution:

If your network protocols are enabled liek TCP/IP  then check

Go to control panel -> services OR open run command and type services.msc
This brings you list of all the services running on your current machine. Look for SQL Server in that list and right click and open properties

Now make sure that you have same account/credentials specified here (which have access to network folder). Restart sql server using same dialog here (under general).

 



Leave a Reply