Monitor Database Replication

[adapterer]

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

[veremin]

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]

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

[veremin]

System tasks are not reflected in RESTful API. Thanks.

[adapterer]

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]

Twice now we've had issues with foreign key errors (resulting in database replication failure)

Can you share more details regarding that?

[adapterer]

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]

Is there any update on whether this can be added?

[veremin]

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

[adapterer]

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]

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.

[sahasrara62]

Hi,
I am also working on this usecase, and unable to find API to gget the status of database replication in session through the RESTFul API. Is there any solution for this? if I need to see database table then where to go?
ps i am new to veeam environment

[oleg.feoktistov]

Hi,

As mentioned above, Enterprise Manager system sessions are not exposed via EM REST API.
The table containing them would be Enterprise.Sessions, but please note that such approach of monitoring these sessions is not supported.

Thanks,
Oleg