SQL Database Restore: Cannot access the specified path or file on the server

“locate backup file cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the file name control in the locate dialog box.”

Solution:
Start > Programs > SQL Server Conifguration Manager > SQL Server Services
Find SQL Server in list and identify the Log On As account

Then go to the backup file location and give permissions to that account. Should now work

Leave a comment