Link to home
Start Free TrialLog in
Avatar of crazywolf2010
crazywolf2010Flag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL server 2008 cluster verify script

Hi,
Does anyone know a utility which will create report on entire SQL server 2008 cluster config?
At this moment I have to use windows Cluster Admin pages to locate relevant info.

Thanks
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

It will depend on the version of Windows under the SQL cluster.  For Windows 2008 R2, you have PowerShell to get you information via script.

Let us know and I can set you on the way.
There's a ton of information in that cluster administration report - what are you looking for in particular? The admin validation process does thousands of tests, and you can't really report on them without going through the validation process. If you're just looking for some configuration points though, you might be able to use powershell is dbaduck suggested to look at some settings in the registry or other configuration points and export them to a report of some kind.

I don't think you'll get anything near as clear or comprehensive as the validation report though, if that's what you're expecting.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial