question

eswar avatar image
eswar asked

Replication

we have repications running in the sql server and some times they are not replicating i used to reinitiate the subscription and then it is again replicating . Is there any solution that it will automatically reinitite the subsription if any error oor the replications fails. Any help Appreciated.
replicationsubscriptionsautomaticany
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are you seeing any error in replication monitor? There is often something noted there when replication stops replication (stopped agent, expires snapshot, etc)
0 Likes 0 ·
Yeah errors are if subscriber properties has changed or logreader agent error or snapshot expired.can we overcome this by any job or procedure ????
0 Likes 0 ·
@kenJ And also by configuring listerner in the replications avoids these type of issues??????
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.