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 device

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

OOPS![:O] Its not sourse but source [;)]

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.

hi all,
Thanks for help and advise. I have solved the problem.
cheers…

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |