Error while restoring - Access denied

[Jaishree]

Hi,
I have installed SQL server 2005 and project server. I have backed up using
the share point central administration site
Operations - Perform a backup.The backup is stored in network.

I need to recover this data in another server.I followed the following
process.

1. Installed SQL server 2005 and named the server as backup
2. Installed project server. I’ve run the Share point’s configuration wizard
..In Operations. Selected Restore from Backup and entered the network location
name to store the backup. Selected new configuration and gave the Backup
server name as the new database server name.
3.Both the original server and the backup server conneted to the network
4. When I try to do this I get the following error message

Cannot open backup device '\\EPM_Backup\Bckup\spbr0003\00000013.bak'.
Operating system error 5(Access is denied.). RESTORE DATABASE is terminating
abnormally.

In the network folder where the backup is stored permissions have been
provided to the Original server, backup server, and the network id from which
I am logged in to restore.

Is the procedure right?
What should I do to rectify the above error and restore this?

When I try to restore using overwrite option. It is successful but I do not
get the data restored in the backup server.

Please guide me in resolving this issue.

 

[Jochen Ruhland]

Hi,

make sure that the account that the SQL server is running under has access
to that share.