Results 1 to 3 of 3

Thread: Log shipping

  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Post Unanswered: Log shipping

    Hi,

    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
    Location
    cape town, south africa
    Posts
    102
    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
    des

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    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.

    hmscott

Posting Permissions

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