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

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

KenJ avatar image KenJ commented ·
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 ·
eswar avatar image eswar commented ·
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 ·
eswar avatar image eswar eswar commented ·
@kenJ And also by configuring listerner in the replications avoids these type of issues??????
0 Likes 0 ·

0 Answers

·

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.