November 15, 2009 at 3:42 pm
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
November 15, 2009 at 5:58 pm
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
March 26, 2012 at 10:31 pm
This was very helpful, thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply