Monday, May 11, 2009

Agents Runnig fine but red X in replication monitor

Recently came accross a problem in a non prod environment where replication replication monitor was marked with red X. It was a SQL 2000 server and replication agents were running fine without error. Server had undergone restores from prod backups and replication was rebuilt after the restores. One of my collegue found the solution in

Running sp_MSload_replication_status did the trick.

The link has solution for SQL 2005 as well.