RESTful knowledge exchange
Post Reply
adapterer
Expert
Posts: 224
Liked: 43 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Monitor Database Replication

Post by adapterer » Jul 19, 2017 5:39 am

Hi,

How can I monitor database replication success or failure under Enterprise Manager > Sessions?

We use the API for billing, and if the replication fails obviously this is bad.

Cheers :D

veremin
Product Manager
Posts: 17078
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin » Jul 19, 2017 2:39 pm

What do you mean exactly by database replication? Replication job that has a VM running specific db application as its source, configuration backup or something else?

adapterer
Expert
Posts: 224
Liked: 43 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer » Jul 20, 2017 1:06 am

In enterprise manager, under configuration > sessions. The task that collects data for all the VBR's.

Image

veremin
Product Manager
Posts: 17078
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin » Jul 20, 2017 5:18 pm

System tasks are not reflected in RESTful API. Thanks.

adapterer
Expert
Posts: 224
Liked: 43 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer » Jul 21, 2017 12:23 am

OK, consider this a feature request then :)

Twice now we've had issues with foreign key errors (resulting in database replication failure) which have required manually editing the database.

If an email could be sent if this task fails, that would be sufficient.

Thank you!

veremin
Product Manager
Posts: 17078
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin » Jul 27, 2017 2:54 pm

Twice now we've had issues with foreign key errors (resulting in database replication failure)
Can you share more details regarding that?

adapterer
Expert
Posts: 224
Liked: 43 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer » Jul 28, 2017 1:14 am

Case # 02210308 - although I'm not sure how much detail is in there as I managed to resolve this myself.

The error was something like "FK constraint, cannot insert duplicate row into dbo.repositories" . I can't remember the exact error or table name, but the content was the table of backup repositories. By deleting these rows in SQL management studio the task was able to run again (I took a DB backup first :) ).

adapterer
Expert
Posts: 224
Liked: 43 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer » Sep 07, 2017 8:20 am

Is there any update on whether this can be added? :)

veremin
Product Manager
Posts: 17078
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin » Sep 07, 2017 11:17 am

Nothing has changed for this matter since my last reply. Thanks.

adapterer
Expert
Posts: 224
Liked: 43 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer » Sep 08, 2017 12:44 am

The database replication is critical for us to get billing data for Cloud Connect clients - we really need 'something' - even a Veeam ONE alert to check that this is working.

veremin
Product Manager
Posts: 17078
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin » Sep 08, 2017 9:47 am

As far as I'm concerned, Veeam ONE does not have an alert you're asking. I believe it should be possible to query SQL database to get this information. Thanks.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest