While setting up SQL Server Replication (Transactional Replication to be specific), I had successfully created the Publication and the Subscriptions, but nothing was being replicated between the publisher SQL Server instance and the subscriber SQL Server instance.
When viewing the subscription details through the Replication Monitor tool, the subscription was not throwing an error, and hanging with the following message:
The initial snapshot for publication is not yet available.
In the post I will explain why this is appearing, and how to resolve the issue and generate the required Replication Snapshot.
Read more →