Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2009-10-12 : 03:23:39
|
Hi AllWe have transactional replication setup on OLTP and DW databases.Yesterday, I have restored the backup of OLTP database from "serverA " to other "serverB" which has the similar transactional replication setup.After restore is done, I see the following error messages in replication monitor of "serverB". quote:
Error messages:The process could not execute 'sp_repldone/sp_replcounters' on 'serverB'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)Get help: http://help/MSSQL_REPL20011The log scan number (54156:9271:99) passed to log scan in database 'serverBdatabase' 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/9003The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017)Get help: http://help/MSSQL_REPL22017The process could not execute 'sp_repldone/sp_replcounters' on 'serverB'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)Get help: http://help/MSSQL_REPL22037
I have even executed the DBCC CHECKDB against these databases and no errors were reported. I have even recreated the publication but still see the same errors.And the snapshot files in the repl folder are getting disapperaed automatically in few seconds after the snapshot is generated.Can you please suggest me how to fix this issue and why this is happening..Help on this is greatly appreciated. Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-17 : 22:34:07
|
| Are you saying that server A and server B both have the same publications? Can't do that.if you mean that server B is replacing server A, recreate the publications |
 |
|
|
|
|
|
could not execute 'sp_repldone/sp_replcounters'