Re-configure Replication after restoring publication database from Backup – Replication Scenario

Sharing one of the interesting scenario I worked today. Somebody messed up the data at publication database (few rows updated with a value which they aren’t supposed to) and publication database was restored from a older backup to rollback the change. Now when log reader agent was started it starting failing with an error: 2012-03-14 01:08:14.360…

2