One of my publications was dropped mistakenly. I restored it from the latest backup but now schema changes are not replicated to the subscribers.
What can I do to re-initialize/fix the publication?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Did you mean afterwards you re-created the publication that you dropped? Afterwards, did you started back the snapshot agent?
You can restore a publication from the latest backup, but you then have to re-publish it. The snapshot agent has to be restarted.