Help replication issue..The process could not execute 'sp_repldone/sp_replcounters

• Free-292871

  Right there with Babe

  Points: 721

  More actions

  November 15, 2009 at 3:42 pm

  #206581

  Hi there everyone,

  I'm trying to setup transaction replication on 1 database and 1 table: Configured in the following way:

  1. \\servename\repldata

  snapagent & logagent service account has full control to this folder

  2. Snapshot agent & logagent account has db_owner to distribution database (i also temporarily gave them sysadmin to try and get this feature working)

  3. created a trans publication and i'm getting the following error message. I can create snapshots OK, but for some strange reason something strange is going on.

  Error messages:

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

  Get help: http://help/MSSQL_REPL20011

  The specified LSN {00000000:00000000:0000} for repldone log scan occurs before the current start of replication in the log {00000a93:00001634:0003}. (Source: MSSQLServer, Error number: 18768)

  Get help: http://help/18768

  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 'MYCHANGESERVER'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)

  Any advice or help would be much appreciated.

  cheers

• Free-292871

  Right there with Babe

  Points: 721

  More actions

  November 15, 2009 at 5:58 pm

  #1079498

  I managed to get this working..

  ran the following commands

  1. dbcc opentran('db') - which shows me that the old LSN was slightly out of date

  2. sp_replrestart - reset the transactional replication

  3. dbcc opentran('db') again and everything looked better and was able to create the publication.

  cheers

• SQLUserC

  SSCrazy

  Points: 2345

  More actions

  March 26, 2012 at 10:31 pm

  #1464692

  This was very helpful, thank you.