Monday 30 May 2011

Replication ERROR "The process could not execute 'sp_repldone/sp_replcounters' on ESHNVSQL "


Step 1: execute the below statements in Publisher database
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 1

and

EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 0


Step 2: execute the below statement in three databases (distribution, nvcorp and nvcorp)

sp_replrestart

Step 3:: execute the below statement in three databases (distribution, nvcorp and nvcorp)

sp_replflush



------http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1145797&SiteID=1

No comments:

Post a Comment