Hi, 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? Please help...
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: From SQL-SERVER-PERFORMANCE From MSDN
Hi, 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, Thulasi.