I have logshipping configured in SQL Server 2008 boxes, some times this goes out of sync for some of databases (few of them are quite large in size) due to LSN mismatch, is there any way to re-sync the logshipping without reconfiguring it through wizard?
My full backups are running over night, even then it never picks them up autometically, to restore them in secondary to re-sync the logshipping. Everytime I need to reconfigure the logshipping through configuration wizard through taking new full backup to re-sync (then it works fine till next failure :crazy
which impacts my backup strategy big time, some of my databases are quite big in size, which makes it even worse...
Am I missing on any setting or something...??
let me know you if you need more details.