Policy Question

• PhilipC

  Hall of Fame

  Points: 3124

  More actions

  October 31, 2011 at 4:10 pm

  #250923

  I'm trying to create a policy that validates that all databases are in Full Recovery mode.

  The problem I'm having is that I want to exclude one database from the policy which is a database named "DBAMonitoring".

  Attached is the Condition I'm creating, which fails each time on the "DBAMonitoring" database. How can I exclude it from this policy?

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  October 31, 2011 at 8:34 pm

  #1401394

  Create a condition, I'd call it Except DBAMonitoring

  Facet will be Database

  Expression will be @Name != 'DBAMonitoring'

  Within the Policy see Against Targets, Choose Except DBAMonitoring

  This should do it I think.

  CEWII