• sanku.raghuram (2/4/2014)


    how about any other way ,

    I can get the destination server to recovery mode.

    Can I directly apply the transaction log back up

    or Do I need to need get full back up again and then followed by transaction log backup

    and then enable the jobs.

    let me know ,, its urgent!

    if you have identified a missing log backup and have you can directly apply it (with norecovery or standby) then start the logshipping jobs.

    If you have not taken another full backup since the one you used to start the log shipping take a differential backup and restore that to the secondary with norecovery, then start logshipping jobs again.

    DO NOT recover the standby database, you will not be able to restore any further logs.

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