When Transaction Log Shipping is setup, 3 jobs are created by SQL server on the secondary database server:
- LSCopy - This job copies the transactions logs from the primary to the secondary server
- LSRestore - This will restore the transaction log which was copied by the previous job
- LSAlert - This job will send any alerts if there are any errors
By looking at the Job History of the LSRestore job, we can see all the transaction logs which are being restored:
This screen will also show the path of the transaction logs - one can therefore compare the timestamps and check if there is any lagging transaction logs.