We have a DB that is doing a transactional replication to one other server. There are three tables it is replicating in the DB. Yesterday the subscriber ran out of disk space. This caused the replication to fail. I tried to start it back up but the subscription failed with the error message
Invalid object name 'MSreplication_subscriptions'.
Currently the subscription is sitting in a "running" status, but states
The initial snapshot for publication <XXXXXX> is not yet available.
Is my only solution to reinitialize the subscription? I'm trying to avoid that if at all possible since the DB is quite large and our pipe isn't that large.
select * from distribution..MSsubscriptions where status = 0
– Kin Shah Dec 4 '18 at 21:12