Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking for advice on how to enable our team to take down and re-start our company systems for maintenance purposes.

The scenario includes

  • several Oracle db machines
  • several MS SQL Server machines with multiple instances
  • windows services (IIS etc.)
  • BizTalk EAI solution
  • Apache and Tomcat instances
  • lots of scheduled tasks

on win2003 and win2008 machines (physical and virtual).

The main focus is on capture all dependencies between said databases and services and tasks connecting to them.

At the moment an enterprise class solution is not an option.

We are considering developing a solution driven by PowerShell scripts but I hope for some more suggestions.


In other words: What technology should I use to develop a flexible solution that will allow me to stop service A, B and C on machine D in the right order and disable task E on machine F when taking down database X?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

We use powershell to manage SQL Server and various applications based on SQL Server, so I can definitely recommend using it. I don't know any specifics of managing Oracle with it, but I know IIS, Windows Services, SQL Server, scheduled tasks are all pretty straight-forward to manage with powershell scripts.

share|improve this answer
    
It's not so much handling the individual items like services and databases as being able to model the dependencies. On SO I was pointed to github.com/JamesKovacs/psake which looks very promising. See answer on stackoverflow.com/questions/2837247/… for details. –  Filburt May 14 '10 at 20:39

SCOM - System Center Operations Manager. Check it out ;)

share|improve this answer
    
This would fall into the enterprise class solution category which is not an option at this point. –  Filburt Sep 24 '10 at 8:00
    
SCE - System Center Essentials. –  TomTom Sep 24 '10 at 10:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.