August 28, 2013 at 5:42 am
Hi everyone.
I have situation that I hope I can get some advice on how to solve.
I need to perform a check on a number of servers , post network outages on about 30 SQL servers.
These are my constraints.
1. Not all SQL servers in same domain so need to connect to them with SQL authentication - which works fine.
2. Not all SQL servers are SQL 2008 so can't use CMS to do a multi query.
3. I only have 1 machine configured to send DB mail. SMTP rules etc. are in place.
So my question is can someone recommend a query to check SQL service status for a number of servers and then email the results out ?
Also how do I loop thru a list of servers ? I currently have them all in a .txt file so if that could be used it would be very useful.
Appreciate any help on this , was getting a bit caught up in it all therefore need some clarity on best way forward.
many thanks
August 28, 2013 at 11:36 am
I have done something similar in the past, although it was all within a single domain. However, you should be able to adjust the basic scripts I've posted to my blog[/url] here to get this done using PowerShell and Remoting.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply