Post reply

Log Shipping copy job failed

  • August 16, 2004 at 5:48 am

    #102158

    Hi all,

    I have configured log shipping with multiple domains.

    Primary Server and Monitor Server in one domain and Secondary Server in another domain.

    Both initializing database and transaction log backup at regular intervals are working fine.

    But Copy job in Secondary Server is not working. Also, job history always shows as job step succeeded eventhough log backups are not copied to Secondary Server.

    If i manually copy log backups to secondary server, restore job works fine. It also updates Monitor Server correctly.

    Network share for log backups in Primary Server has been granted appropriate rights to domain account used for sql server & sql agent services running in Secondary Server.In fact this account has sys admin role in Primary Server too.

    From Secondary Server, if i am able to access the Primary Server and copy log backups manually,

    then why copy job is not working without reporting any error?

    Since it involves different domains, i am looking for ways to troubleshooting this problem from database community.

    Help me in this regard.

    Thanks in Anticipation.

    Senthil.

  • August 17, 2004 at 3:58 am

    #519283

    Hi,

    if you copy manually, you use the security-context of your login user.

    Does copying work if you log into secondary server with the service-account?

    Also the copy-job might fail because at the time it tries to copy the file, the file

    is locked by the backup-job.

    karl

    Best regards
    karl

  • August 17, 2004 at 5:14 am

    #519292

    Yes, i have logged into secondary server with sql server service account and able to access network share for log backups in primary server and copy the log file.

    Also, copy job in secondary server always shows succeeded even though it doesn't copy any log files from primary server.

    Senthil.

  • August 17, 2004 at 5:19 am

    #519293

    could you post the copy command here?

    Best regards
    karl

  • August 17, 2004 at 7:06 am

    #519328

    In Secondary Server, i have used start menu -> run -> \\primaryservername to open and copy the log files.

    Senthil.

     

  • August 17, 2004 at 7:06 am

    #519327

    In Secondary Server, i have used start menu -> run -> \\primaryservername to open and copy the log files.

    Senthil.

     

  • August 18, 2004 at 4:41 am

    #519533

    If you create a job on secondaryserver for the copy-command and log the output to file (second register of job-step) you might get an error-msg for debugging...

    karl

    Best regards
    karl

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply