I restored the publishing database in a replication configuration. Now an getting the error below on th publisher to distribubor stage. the distributor to subscriber step is okay

Question

Error messages:

The process could not execute 'sp_repldone/sp_replcounters' on 'OAFPRIMARY01'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

Get help: http://help/MSSQL_REPL20011

The specified LSN {000117ad:000d1937:0044} for repldone log scan is not a replicated commit record. (Source: MSSQLServer, Error number: 18769)

Get help: http://help/18769

The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017)

Get help: http://help/MSSQL_REPL22017

The process could not execute 'sp_repldone/sp_replcounters' on 'OAFPRIMARY01'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)

Get help: http://help/MSSQL_REPL22037

Answer 1

Hi Stephen Waigi •,

Welcome to Microsoft Q&A forum.

As I understand, you are trying to restore a publishing database in a replication configuration. Now an getting the error when publisher to distributor stage. the distributor to subscriber step is okay.

Please enable logging and let us know the details of the error if appears there:

https://learn.microsoft.com/en-us/sql/relational-databases/replication/troubleshoot-tran-repl-errors?view=sql-server-ver16#enable-verbose-logging-on-any-agent

Check if solutions mentioned here could help in your case:

https://www.sqlservercentral.com/forums/topic/help-replication-issue-the-process-could-not-execute-sp_repldonesp_replcounters

Please share more details about the steps you follow so that we can help better.

Thanks