0

I have SQL Server 2008 R2, configured for log shipping. But backup, copy, restore are successful. But alert at primary and monitor instance say, out of sync error 14421.

I have schedule of 15 min set for all 3 jobs. and alert set for 3times=45 mins. but I still get an error,

Please suggest what to do.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Rams_v
  • 35
  • 4

1 Answers1

0

I would recommend carefully looking through the history for each of the Log Shipping jobs to see if you can find any errors. I have seen there be errors within the history message even though the overall job shows as having completed successfully. Hopefully, you'll find some indication as to why it's getting out of sync.

For more information, you can also right-click your SQL Server instance name -> Reports -> Standard Reports -> Transaction Log Shipping Status

Micah Nikkel
  • 51
  • 4