I implemented Transaction Replication (pull subscription with distributor at subscriber) with initialize from backup. It was working good and today when i checked replication monitor,it shows error on subscription.I can see error message "Invalid object name 'demoview1" in Distributor to Subscriber history.
So i checked the Subscriber database and it don;t have that view and even published database don't have such a view.I checked the published article list and there is no such view. I remember i renamed demoview(published article) to demoview1 as part of testing in publisher.
- How can i get rid of this issue.I ran all agents again,but no help?
- My understanding is ,since i initialized subscriber with backup, i don't have any snapshot in the snapshot folder.So if it was normal replication (with initialize) ,a new snapshot would have get rid of this issue?Please correct me if i am wrong.
3.Do i have to take a backup of publication and restore it at subscription to initialize the subscriber again?