0

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?

  • Did you reinitialized publication after you restored it? – Rajesh Ranjan Mar 23 '18 at 8:37
  • Can you explain restored it from the latest backup? How did you restore? How do you know the options are all same? – SqlWorldWide Mar 24 '18 at 13:06
0

Did you mean afterwards you re-created the publication that you dropped? Afterwards, did you started back the snapshot agent?

0

You can restore a publication from the latest backup, but you then have to re-publish it. The snapshot agent has to be restarted.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.