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

  • Free-292871

    Right there with Babe

    Points: 721

    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

    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

    This was very helpful, thank you.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply