Thanks sharing the details. I have one more question. I see that I have set the restore job to happen 2 min dalay.
so when my job runs first it skipped the transaction logs but when I again ran it it restored it.
do i need to wait for 2 min to be over. do you think that the reason for the log getting skipped.
No idea to be honest. As long as it does restore and allows you to stat within your SLAs I wouldn't worry too much.
Please respond as the earliest.
Am I your employee now?
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass