Predefined policies that come with SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Predefined policies that come with SQL Server...

Predefined policies that come with SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

rmatthias001

Posted Tuesday, September 28, 2010 10:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 11:54 AM
Points: 27, Visits: 97

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

Sqlchicken

Posted Friday, June 17, 2011 11:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:13 AM
Points: 134, Visits: 617

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

Post #1127556

« Prev Topic | Next Topic »

Permissions