SQLTeam.com | Weblogs | Forums

SQL 2014 Managed Backup to Azure Smart Admin issues?

sql2014

#1

I enabled e-mail notifications on our Azure managed backup out of SQL 2014 with this:

Use msdb
Go
EXEC smart_admin.sp_set_parameter @parameter_name =
'SSMBackup2WANotificationEmailIds', @parameter_value =
'enter_your_email_here'

and it e-mails me every 15 minutes which is driving me nuts, but
I am not familiar with very many SQL commands.

Any idea how to either disable it, or change it to only e-mail
me once every 24 hours?

It sends me this exact e-mail and nothing ever changes...
Smartadmin health check report
Datetime Instance name Storage errors Sql errors Credential errors Other errors Deleted or invalid backup file Number of backup loop Number of retention loops
Oct 27 2015 1:15PM SQL1 0 0 0 0 0 2 2


#2

Hi Foofoodar

You can manage your alert rules on Azure. Visit this page and I am sure your will get the help from here.


#3

Jason,

Unfortunately this tab does not exist in my portal view, but I did manage to find it in Azures new portal preview, and there are no alerts setup, this alert was setup from the SQL 2014 Management Studio, not directly in azure, so I'm sure there is a command of some sort I need to run to disable, but I cannot for the life of me figure out what that command is.

Thanks for any help you can provide!