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