MyDoggieJessie (7/8/2013)
I am wondering even stopping the distribution job some batch of transactions was still in progress can cause this or not .
This was my original thought. Perhaps we didn't wait long enough for everything to trickle through...
We can't create a new publication because of the snapshot issue. It would involve an entire snap of all the data and place us in a rather long maintenance window we can't really get approval for right now.
No , it wont require a re-snap thats the point . We are not intializing the subscription as the data is available already in subscription . Replication with backup or Replication with support only is used to avoid massive snapshot generation .