Sample Header Ad - 728x90

Sql Server replication: Initial snapshot for publication is not yet available?

2 votes
3 answers
4742 views
I had setup transactional replication and my distributor, publisher are on same windows server and 2 subscriber one on same server and another on other windows server both using push snapshot. I am getting the message in the synchronization status, that snapshot is not yet available, just a few hours back it was working fine every transaction was synchronized. The only thing i did in between was, added more articles(stored procedures, etc.) to the publication using its properties. Is it causing the issue here, there is no error message displayed. Just that I am not able to get the data replicated
Asked by tsu90280 (175 rep)
Apr 15, 2020, 07:25 AM
Last activity: Apr 17, 2025, 03:53 PM