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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-02 : 08:09:17
|
| Jonathan writes "I've implemented transactional replication on a MSSQL2000 server. It was working fine for a while but recently I restored a backup of the (publisher) database and I seem to have broken the log reader agent. I have tried manually restarting it and get the following err msg,"The process could not execute 'sp_repldone/sp_replcounters' on 'aohrd2'."with the err details,"The LSN (45724:235:1) passed to log scan in database 'HR_Stage' is invalid.(Source: aohrd2 (Data source); Error number: 9003)---------------------------------------------------------------------------------------------------------------The process could not set the last distributed transaction.(Source: aohrd2-HR_Stage-1 (Agent); Error number: 22017)---------------------------------------------------------------------------------------------------------------"I guess the agent now has an invalid log sequence number and this is why it is falling over. Is there anyway to refresh this?" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-12-02 : 12:29:03
|
| I've done something simular in the past.... Drop and recreate the transactional replication (entire publication/subscriptions). You'll want to do a full snapshot of the database and restart the transactional from there.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
Log reader in transactional replication is reporting LSN invalid