Replication Monitor: Cannot Connect to Publisher

Question

Everything It was working fine for a quite long time period, but suddenly this evening I found that I the replication does not work and I cannot browse the publications in the Replication Monitor

Please have a look at the attached image.

The publisher at the bottom is OK - attached and working. But the publisher at the top is attached, but for some reason I cannot browse its Publications. When Selecting something the left side is white. As you can see there is a red "x" which means that there is a problem with the connection.

I tried to remove and then to re-add the publisher, but this does not solve the problem.

In Windows Event Logger I found this Error: "The transaction log for database 'Distribution' is full due to 'LOG_BACKUP'. " And I'm not quite sure what is this....

Any ideas are welcome Regards,

Have you check any logs? Windows Application logs or SQL logs? — SS_DBA, Nov 09 '16 at 20:06
Yes And I found this error The transaction log for database 'Distribution' is full due to 'LOG_BACKUP'. — Kiko, Nov 09 '16 at 20:10
Then you need to backup and truncate the log. Which that should be getting done daily anyways. — SS_DBA, Nov 09 '16 at 20:13
Yes this was the problem, I just had to do it on the Distribution Database — Kiko, Nov 09 '16 at 20:27

score 1 · Answer 1 · answered Nov 09 '16 at 20:28

1

This was the problem:

In Windows Event Logger I found this Error: "The transaction log for database 'Distribution' is full due to 'LOG_BACKUP'. " And I'm not quite sure what is this....

Once I truncated the log for Database Distribution everything was OK

answered Nov 09 '16 at 20:28

Kiko

319
1
4
16

Where to exactly need to navigate in Windows Event logger, what event Id here we are looking for? – meekash55 Jul 27 '23 at 10:28

Replication Monitor: Cannot Connect to Publisher

1 Answers1