Comprehensive data protection for all workloads
Post Reply
ferrus
Veeam ProPartner
Posts: 237
Liked: 31 times
Joined: Dec 03, 2015 3:41 pm
Location: UK
Contact:

SQL Log backup notifications

Post by ferrus » May 18, 2016 8:46 am

We've set up SQL transaction log backup and shipping, on one of our SQL VM backup jobs.
Most things appear to be working correctly - but the e-mail notifications ignore the addresses listed in the job setting (which include our DBA's), and just e-mails the log to the addresses in the global e-mail configuration.
Not sure whether can be fixed, or whether it's a feature request.
Installed version is latest Veeam v8

P.Tide
Product Manager
Posts: 5136
Liked: 443 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL Log backup notifications

Post by P.Tide » May 18, 2016 8:54 am

Hi,

Could you please provide a screenshot of your notification settings? Does the "Test Message" button work? Also do you see any errors in job log?

Thanks

ferrus
Veeam ProPartner
Posts: 237
Liked: 31 times
Joined: Dec 03, 2015 3:41 pm
Location: UK
Contact:

Re: SQL Log backup notifications

Post by ferrus » May 18, 2016 9:15 am

The Notification dialog is pretty standard. I've anonymized the names here - but it's two addresses, semicolon-separated.

All e-mail notifications are working, and the parent job notifications go to the correct recipients - just not the App-Aware SQL Log shipping e-mail.
That just comes to one user (listed in the Global Notification config).

Image
http://picpaste.com/5036282e9760554a5bf ... 1bd503.png

P.Tide
Product Manager
Posts: 5136
Liked: 443 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL Log backup notifications

Post by P.Tide » May 18, 2016 10:01 am

All e-mail notifications are working, and the parent job notifications go to the correct recipients - just not the App-Aware SQL Log shipping e-mail.
Just to make sure we are on the same page - do you mean that the job sends emails to all recepients (user1, user2) when VM backup is finished but you also want to receive an email every time when SQL logs got processed by Veeam?

Thank you.

ferrus
Veeam ProPartner
Posts: 237
Liked: 31 times
Joined: Dec 03, 2015 3:41 pm
Location: UK
Contact:

Re: SQL Log backup notifications

Post by ferrus » May 18, 2016 10:11 am

Not quite. Don't mind if the SQL Log e-mails come on their own schedule, or once a day on the parent VM backup schedule.

The problem is - the e-mail recipients, aren't inherited from the parent VM job, to the SQL Log job.
User1, User2 are set at the VM job level, and correctly receive the VM backup e-mail - but only User1 gets the SQL Log e-mail.

It's not a e-mail client issue, as User2 is missing from the e-mail header.

P.Tide
Product Manager
Posts: 5136
Liked: 443 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL Log backup notifications

Post by P.Tide » May 18, 2016 11:31 am

The problem is - the e-mail recipients, aren't inherited from the parent VM job, to the SQL Log job.
The described behaviour looks unexpected. Please contact support team ans post your case ID in this thread.

Thank you.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 20 guests