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?

| improve this question | | | | |
  • 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?

| improve this answer | | | | |
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.

| improve this answer | | | | |

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.