Troubleshooting failed replication

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.

more ▼

asked Feb 23, 2012 at 03:41 PM in Default

inder gravatar image

211 17 19 22

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest
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.
more ▼

answered Feb 24, 2012 at 06:16 AM

Sacred Jewel gravatar image

Sacred Jewel
1.7k 2 4 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 23, 2012 at 03:41 PM

Seen: 647 times

Last Updated: Feb 24, 2012 at 06:16 AM