After renaming computer, "check on schedule" policies don’t work. How to fix …

Hi, If you rename your computer, then “check on schedule policies” won’t work because the old machine name is embedded in the SQL Agent jobs. To make this (and a lot of other stuff) work after a machine rename, execute the following procedure:  “How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL…


Policy Evaluation Modes

I hosted a PBM break out session in Microsoft MVP Summit 2009 in March. One feedback I got is that the rules for what evaluation modes a policy support are obtuse. I thought that would be a good topic to cover in the blog. In PBM, users can specify the “Evaluation Mode” for a policy,…

2

Out-Of-Box Policies

SQL Server 2008 includes several predefined policies. These are generally associated with best practices and overtime the rules from the Best Practices Analyzer will be implemented as policies for PBM. A number of these have already been implemented and are available to you in one of two forms: First, they’re installed as part of every…

5