Hi, There is transactional replication configured between server A and server B.Last night, it failed.I reinitalized the subscription and it worked.I tried to explore and found error like "The distribution has been marked inactive and must be reinitialized." in replication monitor from distribution to susbcription.I explored sp_browserreplcommands and found a command like ' CALL sp_MS.....'Is there any way I can found what issue caused the replication to fail.Like what command caused replication to fail.
asked Feb 23 '12 at 03:41 PM in Default
I do not think there would be an error. It happens when subscription is not synchronized within a specified period of time. May be your subscriber was offline for more than the maximum length of time before the subscription was deactivated. The best way around this is to set history retention and your publication retention settings to values which exceed the maximum length of time your subscriber could be offline for.
answered Feb 24 '12 at 06:16 AM