Real-time performance monitoring and troubleshooting
Post Reply
sraj
Influencer
Posts: 15
Liked: never
Joined: Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai
Contact:

Veeam SQL Transaction log failure Alerting

Post by sraj » May 28, 2018 8:41 pm

Hi

We have configured the the SQL Tlog application aware processing for an Physical SQL server. The job is configured to take the Tlog backup every 30 minutes and truncate the log

We are seeing few failures during the Tlog schedule which runs every 30 min. But this is not being alerted/shown in the failure job status console.

We were able to monitor the Parent job failure with veeam one alerting. Is it possible to configure the alerting for the Tlog failure also..

Your inputs are appreciated.

Regards
Raj

Vitaliy S.
Veeam Software
Posts: 21631
Liked: 1297 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » May 30, 2018 5:31 pm

Hi Raj,

There is no such alarm in the predefined list, but we have this predefined report that you can schedule to be run on daily basis to review your SQL job stats. Will this help in your situation?

Thanks!

sraj
Influencer
Posts: 15
Liked: never
Joined: Oct 30, 2017 6:55 am
Full Name: Rajesh Samidurai
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by sraj » May 30, 2018 6:07 pm

We have so many SQL Servers and its tough verify each job status as success or failure.

would be great if we can integrate this tlog failure alerting in veeam one Monitoring. .

Vitaliy S.
Veeam Software
Posts: 21631
Liked: 1297 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » May 30, 2018 8:02 pm

I don't have access to the lab right now, but we might have an option to create these alarms. I just need to check if the corresponding event is triggered or not. I will post back tomorrow as soon as I get to the office.

Vitaliy S.
Veeam Software
Posts: 21631
Liked: 1297 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam SQL Transaction log failure Alerting

Post by Vitaliy S. » May 31, 2018 3:34 pm

Ok, confirmed that there is no way to achieve that today. SQL Server jobs (Tlog) do not generate any event that can be used in the alarm creation. We will discuss it with the B&R team and will ask them to add this in our next releases.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests