July 19, 2009 at 5:22 am
Hello:
I have been having issues with the transactional replication. My scenario is: Distributor, Subscriber and Publihser are in the same server. I have one publication database and three subscription databases. When i restore the database replication breaks each time databases are restored. I need help, please help me on this issue. I resolve the issue by disabling the replication and recreate them. Following is the error that i get.
Error messages:
The process could not execute 'sp_repldone/sp_replcounters' on 'Server1'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
The log scan number (144054:9659:4) passed to log scan in database 'UNCF' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. (Source: MSSQLServer, Error number: 9003)
Get help: http://help/9003
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 'OCUDBTS11b'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
July 21, 2009 at 7:04 am
No one has answer for this problem. Please help me out if any of you have any expertise on this problem.Thanks in advance
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply