• State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 5838 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

LogShipping reinitializing the subscriber using multi file backups

pdjames
over 6 years ago

 I'm looking for a way to reinitialize the subscriber using multi backup files. I can backup the publisher manually. However, LogShipping_Sync_Subscriber provides no way to do a custom restore or restore out side of this procedure and then call the procedure.

 

Is there any way to do this?

  • 0 over 6 years ago

    Hello,

    If you perform a "manual" backup that does not use the Log shipping extended stored procedures then you will have to manually restore those backups to your target database. When the log shipping job creates backups it tags them with the plan's ID number.
    The restore job will look for this ID number to identify what plan and database the backups belong to.

    Without that ID the backups will be ignored. So you'll have to restore them using the regular restore procedure. (Disabling all log shipping jobs first and re-enable the jobs after your task is complete)

    Please note you can manually run the sync process using the Log shipping procedures.
    Details are in the help files.



    Hope this helps,

    -Ben-

  • 0 over 6 years ago
    I restore the database manually and then execute the sync subscriber procedure. there will be no backup, so it will pick up restoring the correct tran logs in sequence. Is this correct?
  • 0 over 6 years ago

    If you restore a full backup manually you will not need to sync. Just re-enable the log shipping jobs (pub and sub) and they will pick up with the correct LSN sequence.

    If you run into any log shipping issues or errors please open a support case.

    Hope that helps,
    -Ben-