SQL Server 2005 Log Shipping error cannot open backup device | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
SQL Server 2005 Log Shipping error cannot open backup deviceHi,
I hit the problem when configuring log shipping trying to restore into secondary server it hit the error "cannot open backup device …. operating system error 5"(Access is denied).
how to configure the permission right?
Hello and Welcome to the forums!
The error you specified, occurs when the user account under which the MSSQLSERVER service is running does not have the appropriate permissions to access the sourse folder.
Please refer to the below links to get more information:
OOPS![:O] Its not sourse but source 
The above mention error we will facewhen the Share folder is not having permissions to copy the data from one sharefolder to another server.
While configuring the Log shipping we need tocreate two share folder to place the log file at specified location.Aftercreating the folder right click –>go to properties–> securitytab–>share this folder –> add the group under which account yourconfiguring the LS.finally allow permissions.do the same thing in both serversfor share folders.
Thanks for help and advise. I have solved the problem.