Results 1 to 3 of 3

Thread: Log shipping

  1. #1
    Join Date
    Nov 2003

    Post Unanswered: Log shipping


    we have configured Log Shipping for 1 database. we are dumping the transaction log every 5 mins from the primary server, and shipping it across to the other server, and restoring the same.

    currently, the load is stuck at a place, where 1 transaction log file is missing...

    how can i restore the log, so that i can get the database in sync with the primary database ??

    I am using restore log <dbname> ..... with standby option

  2. #2
    Join Date
    Jun 2003
    cape town, south africa
    I dont think you can skip log files - they must be sequentially loaded...if it is missing you may have to restore a full backup

  3. #3
    Join Date
    Dec 2002
    I agree with couligra's assessment. By design, a log file cannot be skipped over in the restore process. You will get an error indicated that 'LSN XXXX was expected and the first LSN found was XXXX'.

    Gee, now how would I know that?

    Reinitialize your log shipping plan.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts