Hello,
We have LogShipping configured and I got the following message:
Transaction Log Restore skipped (file not found)
We have Sql server 2014, running LogShipping job every 15 minutes and When I checked Sql Server error log it not showing any error but couldn't see the entry for that specific time, It showing Entry for 3:31 PM, 3:45 PM, 4:16 PM, 4:30 PM, and so on but if you see it's missing for 4 PM
Do I have to do anything?
Primary Server
backup_set_id backup_start_date backup_finish_date first_lsn last_lsn
188507 9/20/21 4:16 PM 9/20/21 4:16 PM 1133000001559500000 1133000001559800000
188506 9/20/21 4:01 PM 9/20/21 4:01 PM 1133000001555000000 1133000001559500000
188505 9/20/21 3:46 PM 9/20/21 3:46 PM 1133000001554700000 1133000001555000000
188504 9/20/21 3:31 PM 9/20/21 3:31 PM 1133000001554400000 1133000001554700000
Secondary Server
backup_set_id backup_start_date backup_finish_date first_lsn last_lsn
184192 9/20/21 4:16 PM 9/20/21 4:16 PM 1133000001559500000 1133000001559800000
184191 9/20/21 4:01 PM 9/20/21 4:01 PM 1133000001555000000 1133000001559500000
184190 9/20/21 3:46 PM 9/20/21 3:46 PM 1133000001554700000 1133000001555000000
184189 9/20/21 3:31 PM 9/20/21 3:31 PM 1133000001554400000 1133000001554700000
Thank You!
