We’re currently working on replication SQL Server databases.
We have a question in regards to this. Please let me know if you can help me this by getting me a right resource.
We made the architecture as follows.
Server A (db PANJ.tab1) as publisher and distributor.
Server B (db REPL) as subscriber.
Under Server B, Replication, subscription, it run’s with below status.
“The initial snapshot for article 'Router_Node_OBJ' is not yet available.”
Under Server B, Replication monitor, snapshot agent it shows the below status.
“A snapshot was not generated because no subscriptions needed initialization.”
The initialization went fine when created the subscription. But still cannot find the schema snap shot at the Second server yet (Server B).
We would like to know how we can further go about this problem.