|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:58 AM
Points: 415,
Visits: 737
|
|
Thanks for your Questions and clarifications... Special thanks to Steve...
Still lot of tricks to learn in PBM, will post it soon...
Thanks Jay www.sqldbops.com
Thanks Jay http://www.sqldbops.com
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 6:37 AM
Points: 134,
Visits: 616
|
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: 2 days ago @ 1:42 PM
Points: 2,012,
Visits: 2,839
|
|
Thanks Steve for the explanation. I thought I over-thought.
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 7,078,
Visits: 7,119
|
|
A very useful question. I've learned something new. Policy-based management begins to look more useful.
But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section (http://msdn.microsoft.com/en-us/library/bb510667.aspx) is Policy-Based Management is a system for managing one or more instances of SQL Server 2008. - and that was last updated as recently as November 2009.
Tom Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 6:37 AM
Points: 134,
Visits: 616
|
|
Tom.Thomson (2/12/2010)
A very useful question. I've learned something new. Policy-based management begins to look more useful. But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section ( http://msdn.microsoft.com/en-us/library/bb510667.aspx) is Policy-Based Management is a system for managing one or more instances of SQL Server 2008. - and that was last updated as recently as November 2009.
Actually to add to your excitement, that line is a little misleading. Not only can you manage your 2008 instances but you can manage your 2000, 2005 instances as well as Express/Standard/Enterprise editions. The only caveat is that because some features didn't exist is down-level versions (i.e. no DMV's in 2000, no filestream in anything less than 2008) your policies may not work. In order to get around that when you build a policy you can do an edition restriction and specify a policy to only apply to whichever version/edition you'd like.
============================================================= /* Backups are worthless, Restores are priceless */
Get your learn on at SQL University! Follow me on Twitter | Connect on LinkedIn My blog: http://sqlchicken.com My book: Pro Server 2008 Policy-Based Management
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 7,078,
Visits: 7,119
|
|
Jorge Segarra (2/14/2010) Actually to add to your excitement, that line is a little misleading. Yes, that's what I meant when I said MS must have forgotten to change BOL.
Tom Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594,
Visits: 654
|
|
Tom.Thomson (2/12/2010)
A very useful question. I've learned something new. Policy-based management begins to look more useful. But I guess MS must have changed their mind at some point but forgot to change BOL. The very first sentence in the Administering Servers by Using Policy-Based Management section ( http://msdn.microsoft.com/en-us/library/bb510667.aspx) is Policy-Based Management is a system for managing one or more instances of SQL Server 2008. - and that was last updated as recently as November 2009. Great question, I am glad it came up. I just taught an upgrade class from 2005 to 2008 and BOL had also led me to believe that PBM was for 2008 only. I should have looked a little deeper I guess 
At least I have another selling point for my customers who are considering upgrading!
Keep 'em coming!
Peter Trast Microsoft Certified ...(insert many literal strings here) Microsoft Design Architect with Alexander Open Systems
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:58 AM
Points: 415,
Visits: 737
|
|
Thanks and I've written another article about evaluating policies on mutliple instances (SQL 2008 , 2005 and 2000), that will be published end of this month, I hope that will be more fun... 
Thanks Jay http://www.sqldbops.com
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989,
Visits: 10,529
|
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:58 AM
Points: 415,
Visits: 737
|
|
|
|
|