I have a log ship set-up and yesterday I was informed data has not been updated for couple of weeks. I looked at the 2 servers and the first part is taking place as configured.
the source server is creating the logs placing it in the source DIR and the logs are being moved to the destination DIR, however the destination database is not restoring the logs. I have 2 important questions.
1- how can I resolve the log ship process and make sure it is executing from end to end.
2- how can I get the existing logs from the past 2 weeks restored so the server is up to date.
I have exported the set-up script and is attached.
Logship.sql