kenny 40254 (2/8/2016)
Also, we ran into a situation over the weekend where something is conflicting the restore jobs on the secondary... we appear to have had a conflicting job that was processing the data from the database that was being log shipped to. Assuming that a situation like that is cleared, will the job that executes the restore just be smart enough to pick up where it left off?
Is the secondary configuration set to disconnect users before the restore, otherwise the restore job will fail if the standby database is in use.
If the restores do not occur the process will pick up from the last backup to be applied once users have disconnected from the standby database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉