• The built-in Best Practice Policies from Microsoft are found at C:\Program Files(x86)\Microsoft SQL Server\100\Tools\Policies\DatabaseEngine\1033*

    If the policies folder is not there, you can manually download and install them from the SQL Server 2008 Feature pack

    2008 Version (October release)

    2008 R2 Version

    *This is assuming 64-bit version, default installation path.

    =============================================================
    /* 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