Fun with broken SQL Replication

Recently I’ve spent some time debugging some issues with a client site. One problem that came up during this work (which, sadly wasn’t actually the problem I was looking for) was a set of errors from SQL Replication appearing in the Sitecore logs. In keeping with my previous ranting about keeping your Sitecore logs as error free as possible I spent some time working out how to solve this.

Since I’d not looked at databases at this sort of level for some considerable time, I’m writing down some notes for my future self, next time I have to worry about this sort of thing… Continue reading