SQLTeam.com | Weblogs | Forums

Replication issues - what's a quick fix?


Hope someone can help.

Our only DBA is on annual leave for a fortnight and today we had to restore a database that is replicated to two other servers. This has broken the replication (erroring with something about not being able to run repl_counters).

I read somewhere to use sp_replrestart because the LSNs are out of synch but then read somewhere else not to do this because of the risk of data loss.

Waiting two weeks for the DBA to return isn't an option; what's my best quick-win here?

Can I script out dropping the existing replication set up and recreating it? Would that work and if so what do I do?

Thank you for reading.



Check out the above, that might get you going!!