How often Transaction log reports

VMware specific discussions

How often Transaction log reports

Veeam Logoby ober72 » Fri 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
VMCE V9
ober72
Service Provider
 
Posts: 263
Liked: 38 times
Joined: Fri Jan 24, 2014 4:10 pm
Location: CANADA
Full Name: Geoff Burke

Re: How often Transaction log reports

Veeam Logoby DaveWatkins » Sat 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.
DaveWatkins
Expert
 
Posts: 252
Liked: 61 times
Joined: Sun Dec 13, 2015 11:33 pm

Re: How often Transaction log reports

Veeam Logoby Shestakov » Sun 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!
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: How often Transaction log reports

Veeam Logoby ober72 » Sun 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
VMCE V9
ober72
Service Provider
 
Posts: 263
Liked: 38 times
Joined: Fri Jan 24, 2014 4:10 pm
Location: CANADA
Full Name: Geoff Burke

Re: How often Transaction log reports

Veeam Logoby Shestakov » Sun Jun 12, 2016 6:54 pm

And how often would you like the notifications to work? :)
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

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

Veeam Logoby mdiver » Fri 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
mdiver
Service Provider
 
Posts: 39
Liked: 9 times
Joined: Wed Nov 04, 2009 2:08 pm

Re: How often Transaction log reports

Veeam Logoby Shestakov » Fri 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
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: How often Transaction log reports

Veeam Logoby mdiver » Mon 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
mdiver
Service Provider
 
Posts: 39
Liked: 9 times
Joined: Wed Nov 04, 2009 2:08 pm

Re: How often Transaction log reports

Veeam Logoby Shestakov » Mon 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.
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

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

Veeam Logoby ITesus » Mon 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.
ITesus
Influencer
 
Posts: 13
Liked: 3 times
Joined: Wed Sep 09, 2015 7:36 pm

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

Veeam Logoby Shestakov » Tue 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!
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

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

Veeam Logoby ITesus » Tue 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: Wed Sep 09, 2015 7:36 pm

Re: How often Transaction log reports

Veeam Logoby ITesus » Tue 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.
ITesus
Influencer
 
Posts: 13
Liked: 3 times
Joined: Wed Sep 09, 2015 7:36 pm

Re: How often Transaction log reports

Veeam Logoby Shestakov » Wed 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.
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: How often Transaction log reports

Veeam Logoby ITesus » Wed 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?
ITesus
Influencer
 
Posts: 13
Liked: 3 times
Joined: Wed Sep 09, 2015 7:36 pm

Next

Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 23 guests