Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Thursday, November 19, 2015 7:49 AM
Points: 28, Visits: 134
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: Saturday, February 27, 2016 7:13 PM
Points: 137, Visits: 669
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