SQL Server Performance

SQL Server 2005 Log Shipping error cannot open backup device

Discussion in 'SQL Server 2005 Log Shipping' started by cplimmy, Jul 8, 2009.

  1. cplimmy New Member

    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...
  2. arunyadav Member

    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
  3. arunyadav Member

    OOPS![:O] Its not sourse but source [;)]
  4. rayala.thulasi New Member

    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.
  5. cplimmy New Member

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

Share This Page