Policy Based Management

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  November 27, 2009 at 7:57 am

  #214187

  Hi,

  I'm pretty new to PBM and I've built myself a simple policy and condition based on the following rules;

  @RecoveryModel = Simple OR @ID <= 6

  The idea being an new user db's that are not in simple recovery (its a sandbox server) should fail the condition.

  Everything works spot on but I can only get the policy to evaluate either on demand or schedule and I was really after it running as a prevent policy so that it stops the db from being in the wrong recovery.

  I understand that if you have custom conditions you can only have on demand or schedule evaluation, but I would of expected @RecoveryModel and @ID not to be defined as custom conditions (which I expected to be more T-SQL based statements not listed in the drop down).

  Am I missing a trick here?

  (I should say that I'm doing this in R2 NOV CTP).

  Thanks,

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  November 30, 2009 at 5:16 pm

  #1085597

  if I understood correctly,

  Facets are predefined and we can not write any user defined T-SQL statements on the conditions, may in future editions.

  Also we can evaluate the policies only on demand or on schedule jobs, no other way as of now...

  Thanks

  Thanks
  Jay
  http://www.sqldbops.com