Error messages:
·
The
process could not execute 'sp_repldone/sp_replcounters' on 'SCKNLSSI '.
(Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
Get help: http://help/MSSQL_REPL20011
·
Only
one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and
sp_replshowcmds) can connect to a database at a time. If you executed a
log-related procedure, drop the connection over which the procedure was
executed or execute sp_replflush over that connection before starting the Log
Reader Agent or executing another log-related procedure. (Source: MSSQLServer,
Error number: 18752)
Get help: http://help/18752
Get help: http://help/18752
·
The
process could not set the last distributed transaction. (Source: MSSQL_REPL,
Error number: MSSQL_REPL22017)
Get help: http://help/MSSQL_REPL22017
Get help: http://help/MSSQL_REPL22017
·
The
process could not execute 'sp_repldone/sp_replcounters' on 'SCKNLSSI'.
(Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
Get help: http://help/MSSQL_REPL22037
SOLUTION:-
To clear
the pending transactions, run the following against the published database,
1. Stop the logreader Agent
2. Stop the distribution agent:
exec
sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0,
@reset = 1
Turn on both agents.