118 reputation
14
bio website shanejordan.com
location Ada, MI
age 41
visits member for 2 years, 6 months
seen Jan 6 at 1:05

Software Consultant


Jun
17
awarded  Notable Question
Oct
23
awarded  Popular Question
Jan
31
awarded  Scholar
Jan
31
comment How do i set up an Alert that tells me when a replication of data failed?
I think that answers my question, the validation is not automatic, therefore no event is thrown. Thanks.
Jan
31
comment How do i set up an Alert that tells me when a replication of data failed?
That's a good metric to watch as well. Thanks for that tip.
Jan
31
accepted How do i set up an Alert that tells me when a replication of data failed?
Jan
31
awarded  Student
Jan
31
comment How do i set up an Alert that tells me when a replication of data failed?
I have all that setup and I receive alerts when the repliation agent is stopped or started, but not one that tells me if the data did not sync correctly over to the destination db.
Jan
31
comment How do i set up an Alert that tells me when a replication of data failed?
The agent success and agent failure are events that fire when the replication stops and starts, correct? What about something that would tell me that I had new data come into my source db, but failed to make it over to the destination one? Is that "replication subscriber has passed the data validation" event? Error number: 20575. I have 14150 setup already and working fine. I have 20575 setup with logging with sp_altermessage as well
Jan
31
awarded  Autobiographer
Jan
31
asked How do i set up an Alert that tells me when a replication of data failed?