How to stop SQL database alert in SCOM for Secondary Mirrored database servers

Hi Expert Team,

I need help to automate a SQL database alert generated from SCOM . We used to get an alert  'database backup should be performed' for SQL database servers. But in our project we have Always-on cluster(Mirror) database servers and database backups are performing on Primary  database servers. But SCOM is complaining the same for secondary databases and many such alerts are generating from SCOM.  All these SCOM alerts we receive as incidents in ticketing tool via Orchestrator2012. Our goal is reduction of  such incidents. Therefore i want to automate this kind of  alert to identify which is primary database and trigger alert for only primary database servers and not for secondary database servers. . Is it possible to resolve within SCOM console or can we do anything in Orchestrator2012.

Please guide me how to automate.

Thanks for support!!!
Regards,
Sreenivasa
tscharyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
While this is outside my area of expertise, I do know of a celebrated MVP Cameron Fuller.

He has written a lot about SCOM - has a blog site and has written whitepapers that might help.

I would imagine he would start with customising some management groups (that's where I first came across Cameron back in MOM days)

Here is his blog with a relevant but inappropriately named, post : http://blogs.catapultsystems.com/cfuller/archive/2016/04/08/dont-be-the-admin-who-cried-alarm/ There are a series of links to veeam and worthwhile downloading their whitepapers + videos.

https://www.veeam.com/videos/manage-monitoring-define-sla-mp-7699.html

Hope it helps you, and when (not "if") you find your answers, please let us know back in here. I would imagine you are not alone.

Cheers,
Mark
0
Mark WillsTopic AdvisorCommented:
Hmmm... Might be easier to intercept in Orchestrator ?

I know it is possible to create a runbook and maybe you can use that to decide if a ticket should be produced, or, if mirrored DB, then dont worry.

Again, this is NOT my area of expertise...
1
tscharyAuthor Commented:
Thanks Mark for the response. I have started yesterday design of Runbook to perform this activity. I will share you the information once i done.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Mark WillsTopic AdvisorCommented:
Sounds good, might be easier than trying to isolate the backup alert in scom.

As a fallback...

If you or your company has Powershell expertise, there is a truckload of SCOM related cmdlets

It maybe possible to intercept with resolve-scomalert : https://docs.microsoft.com/en-us/powershell/module/operationsmanager/resolve-scomalert?view=systemcenter-ps-2016
And then set an appropriate Backup alert - maybe with a custom resolution state - set-scomalert : https://docs.microsoft.com/en-us/powershell/module/operationsmanager/set-scomalert?view=systemcenter-ps-2016
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark WillsTopic AdvisorCommented:
G'Day tschary,

How are you going with this problem ?

Hope that you have had some successes by now :)

I would love to hear back from you...

Cheers,
Mark Wills
1
tscharyAuthor Commented:
I checked in SCOM and Orchestrator to identify the database backup servers primary\secondary. it is possible.
0
Mark WillsTopic AdvisorCommented:
Very pleased to hear you are on top of it. That's very good to hear....
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Center Operations Manager (SCOM)

From novice to tech pro — start learning today.