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