Search

Wednesday, July 27, 2011

fix failing replication after restore

this code can fix the errors you will have after restoring an replicated database. Run it on the databases that receives the replication and is restored.:

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

No comments:

Post a Comment