ansz5 (8/1/2008)
I am trying to restore a database on SQL Server 2005, using the backup placed on a different server ( in same domain). I have shared the folder and tried the same with sharing the complete drive too.The account, I am using, has been granted full permisisons... but still when I type the complete path ( in file name test box), the message says..the database engine cannot find the specified path or the account does not have access to it. Should the server(with shared folder) have SQL Server installed on it..???
Also what should be the computer name here - "\\ComputerName\Shared folder\Backup\abc.Bak" I used the local computer name (in case of mapped drive) and the other server name in case of shared folder.
Pls advise.
Thanks !!!
Does the account running SQL Server have access to the share? If the account is not a domain account, then you cannot get access to the shared folder.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs