up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
60% accept rate
feedback

2 Answers

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.

link|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
feedback
up vote 0 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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