Policy Based Management (PBM)

  • Ron McCullough

    SSC Guru

    Points: 63877

    Comments posted to this topic are about the item Policy Based Management (PBM)

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • SQAPro

    Right there with Babe

    Points: 742

    The question is partially wrong.. Since there is an option to store the policies in an XML file, it should say "IF stored in a database.." or perhaps make reference to 'active policies" because it's entirely possible to go looking for and not find any policies in MSDB if they've been exported and stored in XML files.

    it's perhaps a technicality, but many of these questions seem to hinge on that sort of thing. As I understand it, there are a number of example 'best practices' sort of policies shipped with 2008, and they are all 'stored' (in the true sense of storing something that's not being used) in XML form.

  • Lynn Pettis

    SSC Guru

    Points: 442144

    Maybe I am reading it wrong, but it looks to me that if the policy isn't in msdb it can't be used. If this isn't true, please let me know.

  • SQAPro

    Right there with Babe

    Points: 742

    Lynn Pettis (2/18/2009)


    Maybe I am reading it wrong, but it looks to me that if the policy isn't in msdb it can't be used. If this isn't true, please let me know.

    That's now I read it also.

    You'd mostly store a policy to xml format in order to copy it to another server.. or perhaps as a way to archive and document older versions of policies in case you needed to roll back to them at some point. It might in fact be rather prudent to export a policy to an xml as a way to store a backup of the policy, before making changes to it.

  • TomThomson

    SSC Guru

    Points: 104772

    Nice clean question and nice clean answer.

    I think the "policy stored in XML file" thing is a complete red herring - if the policy isn't in MSDB it isn't a real policy, just something from which a real policy can be generated.

    Tom

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply