Enterprise Manager - registered instances icons

[daglugub37]

Does anyone know what all the different icons mean next to each registered server.

eg white circle w/ green triangle, green circle w/white triangle, red circle, white circle?

 

[SQLDenis]

green means it's running, red means it is stopped, white means unknown (just click on the plus and it will turn red or green)



“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[mrdenny]

White circle & green arrow = running, but you are not connected to it
Green circle & white arrow = running, you are connected to it
red = Windows is running but SQL is stopped
white = Can not connect to the server to tell if it's running or not.

99% of the time red or white are bad. If you have a server in the DMZ and you don't have file share rights to it, the icon will show white (I've got a server like that).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com