SQL Log ship fails with 14421 error after several days
Posted on 2011-03-24
I'm having a big issue with my log ship for Reports, The logs are being shipped to a second server running the copy of the database for report purposes.
for the life of me I cant figure out why the restore of logs fail after several days of running with no issues.
I set the system up after looking at a couple reasons for that 14421 error like (time, and log maintenance). these do not seem to be an issue as I removed the maintenance and the time on the 2 servers are synced to a second or 2.
I need some help resolving this issue please has anyone seen this issue before, I don't know why it would run for several days and stop on the last reset I started the process on Friday 3/18 ran with no issues till 3/22.
This is an important one for me, all you SQL 2008 experts out there please help.