You also might have an open transaction on the DB. Run DBCC Opentran and see how old the oldest one is. Active transactions are not flushed out of the log...

Did you verify manually that data is being replicated?

It sounds like everything is working fine, and the only issue is that when you launch replication monitor from the subscriber, it...

Rajat Jaiswal-337252 (8/13/2010)

---

desmith 68071 (8/12/2010)

---

The more important question here is why would you try to shrink the log? 60mb is extremely small for a 100gb database (unless you meant 60GB...

If the log backup was taken with the log backup job just run at a non-scheduled time, you don't have to do anything.

If someone went and manually ran a backup...

The more important question here is why would you try to shrink the log? 60mb is extremely small for a 100gb database (unless you meant 60GB log). Shrinking it will...

Usually when my log shipping fails, I'll manually restore the next log and then delete it and all prior ones. 9 times out of 10, the job then picks up...

Create the login (either sql or windows), and then run this. Copy & paste the output and exec. There's probably more efficient ways, but I still use cursors for small...