• Satish-1028188 (9/18/2012)


    Guys,

    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.

    Thanks

    ~Satish

    Firstly check the LS jobs, especially the restore job carefully for any errors.

    Check you do not have any log backups occuring against the Log Shipped databases outside of the LS backup job.

    You can resume LS from a differential backup, see my article at this link.

    it would be nice to get an idea of the schedules and types of your backup jobs and the point at which they break

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉