I have a database "Sales" on sql server 2005 server named SrvPro and this database is backuped automatically everyday to this shared folder called Backup folder with Sales.bak then this backuped database is restored everyday on the sql server 2012 with the same name with a job named Restore..but when I check the job history on sql server 2012 server, ı get this error "
Executed as user: NT SERVICE\SQLSERVERAGENT. Cannot open backup device '\\SrvPro\e$\Backup\Sales.bak. Operating system error 32(The process cannot access the file because it is being used by another process.). [SQLSTATE 42000] (Error 3201) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
The job failed. The Job was invoked by Schedule 9 (Restore). The last step to run was step 1 (Restore).
Sql server Agent is working as NT Service\SQLSERVERAGENT on sql server 2012(REstored server)
Backup folder has Everyone Full permission on SrvPro(Backuped server)
what should I do to fix this problem?