What should I do when the log shipping fails?
The log shipping job actually works as following :
- Create log or other type of backup from source database .
- Select backup , include backups created in backup job or previous log shipping job that not shipped.
- Restore backups to target database.
That is , even this time it fails (in backup or restore stage ), when it next runs , it will continue from last failure time point, and it can select backup or logs necessary automatically to restore to target database.