Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Predefined policies that come with SQL Server 2008 Expand / Collapse
Posted Tuesday, September 28, 2010 10:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 9, 2015 8:31 AM
Points: 28, Visits: 129
I am studying Policy Based Management and I don't seem to have the 53 predefined policies that supposedly ship with SQL server 2008. I am running R2 Developer. I spent some time searching to find where these can be downloaded from but have not had any luck as yet. Does anyone have any info on where I can find them? Thanks.
Post #994612
Posted Friday, June 17, 2011 11:28 AM



Group: General Forum Members
Last Login: Monday, March 23, 2015 11:56 AM
Points: 137, Visits: 656
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:
My book: Pro Server 2008 Policy-Based Management
Post #1127556
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse