June 29, 2007 at 10:44 pm
Hi all,
I am facing problem when start log reader agent in publisher database.
error is : The process could not execute 'sp_repldone/sp_replcounters' on 'ABBLCCIS'
Error Details is :
The LSN (27662:1066:23) passed to log scan in database 'CCISDB' is invalid.
(Source: ABBLCCIS (Data source); Error number: 9003)
---------------------------------------------------------------------------------------------------------------
The process could not set the last distributed transaction.
(Source: ABBLCCIS-CCISDB-9 (Agent); Error number: 22017)
-------------------------------------------
Below is the description of my changed.
I have one publsher and 66 subscriber databases
I went to change my publsher database server. I took full db backup of publisher and all system database.
Then i take ghost of my server and applied to new server.
Then i restore publisher database with following statement
RESTORE DATABASE CCISDB FROM DISK = 'D:\CCISDB.BAK' WITH MOVE 'CCISDB_DATA' TO 'E:\CCISDB_DATA.MDF', MOVE 'CCISDB_Log' TO 'E:\CCISDB_Log.LDF', KEEP_REPCLICATION, REPLACE
Then restore all system database and start replication agent.
I found all things are ok. only Log agent show error
if you know the solution or have an experience the same, pls help me.......
Jahangir hossen
July 1, 2007 at 9:34 am
July 1, 2007 at 11:49 pm
My previous mentioned issue has been solved. I have followed happycat59 suggestion.
stop all replication agent and took backup and restore in new envirnment. start all agent/services and my replication is ok
thank all
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply