Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Database icon preceded by scroll icon with red x

SSMS 2008 R2, connecting to a 2008 instance shows the above glyph in SSMS Object Explorer. None of our other instances show that icon. I've moused over it in the vain hopes that I'd get a useful tooltip but to no avail.

I assume it's related to a failure we had this past weekend. Could someone provide a more authoritative response on what that icon means and any action I should direct my DBAs to take to clear it up?

share|improve this question
Yep, what Martin said. Check any policies you may have setup. – jonvan Nov 14 '11 at 15:37
Excellent, that was the fix. DBAs have created their first Policy here and it seems the failure violated it. – billinkc Nov 14 '11 at 15:49
What's the protocol on this question? Delete it, @MartinSmith converts it to an answer? – billinkc Nov 14 '11 at 15:50
@billinkc preferably have MartinSmith convert to an answer. – jcolebrand Nov 14 '11 at 17:25
up vote 3 down vote accepted

This is documented in BOL under "Administering Servers by Using Policy-Based Management"

For failed policies, Object Explorer indicates a critical health warning as a red icon next to the target and the nodes that are higher in the Object Explorer tree.

I've not used policy based management myself so am not entirely clear what this means. Through the UI I couldn't see any way of denoting a policy condition as having any particular severity.

I've made this answer community wiki in case someone more familiar with the subject area wants to expand upon it.

share|improve this answer

Your Answer


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.