January 21, 2014 at 3:43 am
Hello Masters,
We have around 47 MSSQL Servers and have around 1400 databases in it. We are monitoring them manually and runnig backup check script manually. It consumes almost 3-4 hours a day !
Now planning to automate backup check and health check using any script. I am not good at scripting.
Can anyone help me how to automate such task ?
I want the backup result in excel sheet. so that at a glance can check if any backup fails. I google and found VBScript and Powershell are the most famous medium to do so. I tried some online given script but it fails with me as I dont know the modification needed.
Any help\guidence regarding this automation are welcome.
Jeet.
January 21, 2014 at 9:30 am
jitendra.padhiyar (1/21/2014)
Hello Masters,We have around 47 MSSQL Servers and have around 1400 databases in it. We are monitoring them manually and runnig backup check script manually. It consumes almost 3-4 hours a day !
Now planning to automate backup check and health check using any script. I am not good at scripting.
Can anyone help me how to automate such task ?
I want the backup result in excel sheet. so that at a glance can check if any backup fails. I google and found VBScript and Powershell are the most famous medium to do so. I tried some online given script but it fails with me as I dont know the modification needed.
Any help\guidence regarding this automation are welcome.
Jeet.
With that many Sql Servers and Databases you might be better off getting hold of a third party monitoring tool to do the heavy lifting for you especially if you are new to scripting.
If you do want to have a go at it then Powershell certainly does fit the bill but there is a learning curve involved so you'd need to be wary of running your scripts against your prod. databases.
What scripts did you download and what went wrong?
Be a little wary of running scripts you don't fully understand against your sql servers though.
February 10, 2014 at 4:01 pm
jitendra.padhiyar (1/21/2014)
Hello Masters,We have around 47 MSSQL Servers and have around 1400 databases in it. We are monitoring them manually and runnig backup check script manually. It consumes almost 3-4 hours a day !
Now planning to automate backup check and health check using any script. I am not good at scripting.
Can anyone help me how to automate such task ?
I want the backup result in excel sheet. so that at a glance can check if any backup fails. I google and found VBScript and Powershell are the most famous medium to do so. I tried some online given script but it fails with me as I dont know the modification needed.
Any help\guidence regarding this automation are welcome.
Jeet.
Hi...
You desperately need a database monitoring tool. Scripting, especially into Excel, buys you nothing except a liot of work reinventing the wheel.
Here are the ones that I know will alert you if a database isn't backed up in X days (you choose X):
--Dell (Quest) Spotlight on SQL Server Enterprise
--SQL Sentry
--RedGate Performance Monitor
--Idera
Pricing and power are up to you. However, any one of these tools will multiply your power as a DBA by an order of magnitude. You will not only get alerted for missing backups, but just about any SQL, Windows, Replication or other issue that could require your attention.
We use Spotlight here and we are consistently on top of every issue. We have spent 2 years tuning the alerts, and now we can concentrate not on mere health-check issues but on proactive improvements to the database. The repository of historical information allows us to generate trend reports and project capacity (with ease). I cannot stress enough how important it is to have a good monitoring tool where you have other engineers perfecting metrics that you've not even considered monitoring yet!
Get a free demo today and play. Spotlight requires no client to install on target machines; it simply runs on its own machine and accumulates stats into its own DB. You have nearly 50 machines running 1400 databases? Your management should be demanding that you have an enterprise quality monitoring tool!
Thanks
John.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply