SQL Server Performance

Log Shipping failed

Discussion in 'ALL SQL SERVER QUESTIONS' started by jjsqldba, Sep 7, 2012.

  1. jjsqldba New Member


    We have a log-shipping set up on the production server for reporting purpose.
    Unknowingly, I have set up a backup strategy which also includes trans-log backups.
    So, my log-shipping failed. Restoration job on the second server failed.

    Is there any way I can get back the secondary database on Server2.
    Secondary Database is in (StandBy mode/Readonly)

    Can anyone help me getting back my secondary server database back?

    (I will be getting a daily full back up at 12AM and Tran-log backup for every hour)
  2. ghemant Moderator

    Do you mean you need to get your secondary database online ? If so, you can use RESTORE DATABASE WITH RECOVERY for the purpose. Sorry, but I still did not understand what exactly you want to achieve here?
  3. Shehap MVP, MCTS, MCITP SQL Server

    For legibility about Transaction log backups , tjey are consecutive backup so if anyone is missed or lost at a certain time time you can restore any backup after that time, so you have no enough choice except restore a full backup from primary DB and reconfigure transaction log shipping as ghemant said

Share This Page