I'm running Log Shipping between two servers and I see all the .trn files getting moved from primary server to secondary server. However it's failing to apply the logs at secondary server. The message from Log Shipping restore log job step states "Skipped log backup file. Secondary DB".
Is there anything I'm missing, any help will be greatly appreciated.