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: 160
Liked: 24 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: 13266
Liked: 968 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: 160
Liked: 24 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: 13266
Liked: 968 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: 160
Liked: 24 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: 13266
Liked: 968 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: 160
Liked: 24 times
Joined: Mon Oct 12, 2015 11:24 pm


Return to RESTful API



Who is online

Users browsing this forum: No registered users and 2 guests