Discussions specific to the VMware vSphere hypervisor
ober72
Service Provider
Posts: 358
Liked: 44 times
Joined: Jan 24, 2014 4:10 pm
Full Name: Geoff Burke
Location: CANADA
Contact:

How often Transaction log reports

Post by ober72 » Jun 10, 2016 7:16 pm

Hi Folks,

Just a quick question, how often should I be getting email notifications from my SQL transaction log backups that occur every 15 minutes?

I think by default they go out once a day but is there a way to increase the number. This is not for the main sql VM but for the log backups.

thanks
Geoff Burke
Veeam Certified Architect

DaveWatkins
Expert
Posts: 320
Liked: 85 times
Joined: Dec 13, 2015 11:33 pm
Contact:

Re: How often Transaction log reports

Post by DaveWatkins » Jun 11, 2016 11:09 pm

I've wondered the same thing. In saying that I do get them more than once a day if they start failing but, and this is more concerning to me, I don't get an email when the log backups initially fail, there is always some level of delay, sometimes hours. The logging errors also regularly seem less than conclusive. The one I see most often is that the log failed to copy to the proxy, when the real issue is it failed to copy to the C drive of the SQL server because the log had grown so much that the C drive wasn't large enough. So really the issue is a space issue.

Shestakov
Veeam Software
Posts: 5969
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: How often Transaction log reports

Post by Shestakov » Jun 12, 2016 2:13 pm

Hello,
You should get notification if log backup fails. Would you like to get notifications of successful log backups every 15 minutes or so?
Thanks!

ober72
Service Provider
Posts: 358
Liked: 44 times
Joined: Jan 24, 2014 4:10 pm
Full Name: Geoff Burke
Location: CANADA
Contact:

Re: How often Transaction log reports

Post by ober72 » Jun 12, 2016 6:00 pm

Thats ok it would be overkill every 15 minutes :). Just wanted to confirm that they come out once a day. I did get one that said error but everything below was successfully backed up but that my have been a one off.

cheers
Geoff Burke
Veeam Certified Architect

Shestakov
Veeam Software
Posts: 5969
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: How often Transaction log reports

Post by Shestakov » Jun 12, 2016 6:54 pm

And how often would you like the notifications to work? :)

mdiver
Service Provider
Posts: 41
Liked: 9 times
Joined: Nov 04, 2009 2:08 pm
Contact:

[MERGED] Feat.req: special email option for log-shipping sub

Post by mdiver » Dec 02, 2016 3:59 pm

From two customer projects with larger customers I would like to bring up this request.

With Oracle log-shipping we sometimes use intervals down to 10 min.
The email notification settings are handled by the main backup job in B&R.
Normally you would definitely like to know if the main job fails - so email alerts has to be switched on.
But then, if only the log-shipping fails, you get hammered by the error mails every 10min.

Three options IMHO would be reasonable:
  • have different notigication settings for the log-shipping (might be another user group to receive the mail)
  • switch of email notification only for the log-shipping
  • best option: have the option to only get a summary of the log-shipping errors - maybe together with the main jobs result
Maybe for V10... :wink:

Regards,
Mike

Shestakov
Veeam Software
Posts: 5969
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: How often Transaction log reports

Post by Shestakov » Dec 02, 2016 4:46 pm

Hello Mike,
How often would you like the notifications to work? Isn`t each 10 minutes too often?
Thanks

mdiver
Service Provider
Posts: 41
Liked: 9 times
Joined: Nov 04, 2009 2:08 pm
Contact:

Re: How often Transaction log reports

Post by mdiver » Dec 05, 2016 8:44 am

Customer wants logs to be shipped every 10 mins. It's an SAP system. But I think my ideas would be applicable to longer intervals also (e.g. 1hour).

Best would be to have the mail notification for log-shipping to be configurable fully independently from the main job. So we could even have a different email target (DB admins).
In addition it would be great to be able to (optionally) reduce the log-shipping notification to a daily summary - so if one DB fails for some time for a known reason (migration, maintenance), one is not spammed by errros.

Thanks,
Michael

Shestakov
Veeam Software
Posts: 5969
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: How often Transaction log reports

Post by Shestakov » Dec 05, 2016 12:00 pm

Thanks for a nice feedback, Michael!
mdiver wrote:In addition it would be great to be able to (optionally) reduce the log-shipping notification to a daily summary - so if one DB fails for some time for a known reason (migration, maintenance), one is not spammed by errros.
That`s actually how it works now if you backup the VM daily. In a case of log shipping error the "main" job will give you a warning.

ITesus
Influencer
Posts: 13
Liked: 3 times
Joined: Sep 09, 2015 7:36 pm
Contact:

[MERGED] How to turn off 15 minute sql transaction log error

Post by ITesus » Feb 06, 2017 10:29 pm

When I have an issue with the sql transaction log backups that are part of my daily full, I receive an email alert every time it fails (which is every 15 minutes) until it is resolved (which happens once the daily full runs again). I would like to turn those alerts off without turning error notifications off for the daily full itself.

I get a nice 24 hour summary notification from Enterprise Manager too, so I will still be informed of sql transaction log success/warning/failures for each day. I just don't need an email every 15 minutes. Is that possible? I cannot find a setting to disable or modify those alerts without changing the alerts for the entire daily full job.

Shestakov
Veeam Software
Posts: 5969
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: How to turn off 15 minute sql transaction log errors

Post by Shestakov » Feb 07, 2017 9:53 am

Hello,
What product version are you at?
There is no UI option to disable the notification, but we may think of workaround.
By the way, do you also use Veeam ONE?
Thanks!

ITesus
Influencer
Posts: 13
Liked: 3 times
Joined: Sep 09, 2015 7:36 pm
Contact:

Re: How to turn off 15 minute sql transaction log errors

Post by ITesus » Feb 07, 2017 4:12 pm 1 person likes this post

Thanks for the response. I'm on version 9.0.0.1715. It doesn't need to be a UI option, a work around would be fine. I do use Veeam ONE (and love it).

ITesus
Influencer
Posts: 13
Liked: 3 times
Joined: Sep 09, 2015 7:36 pm
Contact:

Re: How often Transaction log reports

Post by ITesus » Feb 07, 2017 8:07 pm

mdiver wrote:In addition it would be great to be able to (optionally) reduce the log-shipping notification to a daily summary - so if one DB fails for some time for a known reason (migration, maintenance), one is not spammed by errros.
Shestakov, you said in response to mdiver "That`s actually how it works now if you backup the VM daily. In a case of log shipping error the "main" job will give you a warning." Is this as of 9.5? Because it is not that way in 9. Unless I'm missing something. But this thread you merged me into is exactly the same as my question. Thanks.

Shestakov
Veeam Software
Posts: 5969
Liked: 521 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: How often Transaction log reports

Post by Shestakov » Feb 08, 2017 11:27 am

Hello,
v9.5 should work same as v9, you have instant notification of errors, however warnings and success statuses are shown only when the main job runs. As far as I know you can use regkey to change the behavior.
As I said we are planning to add flexibility to transaction log log backup notifications in Veeam ONE.

ITesus
Influencer
Posts: 13
Liked: 3 times
Joined: Sep 09, 2015 7:36 pm
Contact:

Re: How often Transaction log reports

Post by ITesus » Feb 08, 2017 5:51 pm

Shestakov wrote:...As far as I know you can use regkey to change the behavior.
Could you provide me with the regkey I need to modify?

Post Reply

Who is online

Users browsing this forum: enrique.frisoli and 22 guests