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 !!!