Central Management Server with Policy Based Management

• Loundy

  SSCertifiable

  Points: 6080

  More actions

  February 28, 2012 at 6:36 am

  #251449

  Hi All,

  I'm playing around with a Central Management Server created under a SQL2012 named instance. I've registered a group which contains 3 development servers all running 2008 R2 (all 4 instances are enterprise).

  On one of the 2008R2 servers I have an "on demand" policy to check all databases to ensure that they are set to Simple Recovery Model.

  The problem is that when I try to evaluate the policy using the CMS no Policies appear. The policy is fine when connecting to the server manually.

  Does anyone have any ideas why it wouldn't be showing in the CMS?

  Cheers,

  [font="Times New Roman"]There's no kill switch on awesome![/font]

• Loundy

  SSCertifiable

  Points: 6080

  More actions

  February 28, 2012 at 10:24 am

  #1452721

  Ok - so i tried the following and still nothing showing in CMS....

  Imported a policy from within the cms which deployed fine to all registered servers

  Thought it might be to do with "on demand" so made a scheduled policy and made sure it was enabled but still nothing showing in cms.

  wondering if its something to do with having sql2012 as the cms.....

  [font="Times New Roman"]There's no kill switch on awesome![/font]