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?
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-
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-
