I have set up transactional replication using backup restore something like this.
1) Backup A db
2) Restore it as B
3) Create Publication
4) Create subcription with no snapshot.
Now I want to add SP as article and I added it to publication.
Now My confusion starts....I thought we need to generate a new snapshot and reinitalize subscription.
am I right.....?assuming it what I did is right click publication and view snapshot status , started agent it says there is no A snapshot was not generated because no subscriptions needed initialization.and then tried running distribution agent ....but I dint see SP in B.
Can someone tell me how to proceed furthur or anything I am missing..?