Restore is not happening

  • We have configured the log shipping.

    here backup job and copy jobs are working fine but restoring is not happening in secondary server

    what could be the reason

  • It could be any number of things. Your best bet is to look at the error log and the execution log of your mirroring operation in SQL Agent. There's no way for me to suggest an answer without more data.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • New persopn (5/8/2013)


    We have configured the log shipping.

    here backup job and copy jobs are working fine but restoring is not happening in secondary server

    what could be the reason

    You likely have t-log backups occurring on the primary outside of the LS jobs which are not being copied to the secondary. The restore is failing as the files are being skipped. Check carefully the restore job step history and post details back.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • What is the state of database in secondary server? If it is in Standby mode, have you checked the Checkbox "Disconnect uses in the databse when restoring backup"

  • New persopn (5/8/2013)


    We have configured the log shipping.

    here backup job and copy jobs are working fine but restoring is not happening in secondary server

    what could be the reason

    Hi,

    Better you share the error log to understand the exact issue....

    Satish

  • Hi

    there is any number of reasons, like the agent can not access to log backup to restore or you are using the secondary database and database is in Use .

    for help us and you , share the error log .

    .

    .

    shayan

  • you have to need check errorlog for this issue

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

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