Monitor Database Replication

RESTful knowledge exchange

Monitor Database Replication

Veeam Logoby adapterer » Wed 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
adapterer
Service Provider
 
Posts: 206
Liked: 32 times
Joined: Mon Oct 12, 2015 11:24 pm

Re: Monitor Database Replication

Veeam Logoby v.Eremin » Wed 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?
v.Eremin
Veeam Software
 
Posts: 13864
Liked: 1037 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Monitor Database Replication

Veeam Logoby adapterer » Thu Jul 20, 2017 1:06 am

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

Image
adapterer
Service Provider
 
Posts: 206
Liked: 32 times
Joined: Mon Oct 12, 2015 11:24 pm

Re: Monitor Database Replication

Veeam Logoby v.Eremin » Thu Jul 20, 2017 5:18 pm

System tasks are not reflected in RESTful API. Thanks.
v.Eremin
Veeam Software
 
Posts: 13864
Liked: 1037 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Monitor Database Replication

Veeam Logoby adapterer » Fri 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!
adapterer
Service Provider
 
Posts: 206
Liked: 32 times
Joined: Mon Oct 12, 2015 11:24 pm

Re: Monitor Database Replication

Veeam Logoby v.Eremin » Thu 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?
v.Eremin
Veeam Software
 
Posts: 13864
Liked: 1037 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Monitor Database Replication

Veeam Logoby adapterer » Fri 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
Service Provider
 
Posts: 206
Liked: 32 times
Joined: Mon Oct 12, 2015 11:24 pm

Re: Monitor Database Replication

Veeam Logoby adapterer » Thu Sep 07, 2017 8:20 am

Is there any update on whether this can be added? :)
adapterer
Service Provider
 
Posts: 206
Liked: 32 times
Joined: Mon Oct 12, 2015 11:24 pm

Re: Monitor Database Replication

Veeam Logoby v.Eremin » Thu Sep 07, 2017 11:17 am

Nothing has changed for this matter since my last reply. Thanks.
v.Eremin
Veeam Software
 
Posts: 13864
Liked: 1037 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Monitor Database Replication

Veeam Logoby adapterer » Fri 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.
adapterer
Service Provider
 
Posts: 206
Liked: 32 times
Joined: Mon Oct 12, 2015 11:24 pm

Re: Monitor Database Replication

Veeam Logoby v.Eremin » Fri 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.
v.Eremin
Veeam Software
 
Posts: 13864
Liked: 1037 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to RESTful API



Who is online

Users browsing this forum: No registered users and 1 guest