Sign In
SQL Server Policy-Based Management
This blog is dedicated to Policy-Based Management introduced in SQL Server 2008
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Best Practice
Check On Change
Check On Shcedule
Conditon
Evaluation Mode
Facets
General
Management Studio
msdb
Nonsense
Policy
PowerShell
Sample
Security
SQL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server Agent
Archive
Archives
August 2010
(4)
April 2009
(2)
September 2008
(1)
July 2008
(5)
June 2008
(3)
May 2008
(1)
April 2008
(4)
August, 2010
MSDN Blogs
>
SQL Server Policy-Based Management
>
August, 2010
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server Policy-Based Management
Why does a property show up in > 1 facet? Why do some facets support CoC:Prevent, but others not?
Posted
over 2 years ago
by
sqlpbm
0
Comments
Last week, Shaun Stuart posted some questions on his blog about PBM " strangeness ". He was wondering why some properties like "AutoClose" show up in more than one facet, and then why some of those facets support "check on change : prevent" but others...
SQL Server Policy-Based Management
After renaming computer, "check on schedule" policies don't work. How to fix ...
Posted
over 2 years ago
by
sqlpbm
0
Comments
Hi, If you rename your computer, then "check on schedule policies" won't work because the old machine name is embedded in the SQL Agent jobs. To make this (and a lot of other stuff) work after a machine rename, execute the following procedure: ...
SQL Server Policy-Based Management
Clarification around "Data and Log Files ..." and "Backup Files ..." policies
Posted
over 2 years ago
by
sqlpbm
0
Comments
Hi, We ship these two Best Practices policies Place Data and Log Files on Separate Drives Backup Files Must Be on Separate Devices from the Database Files Unfortunately, neither of those two policies can detect separate physical devices...
SQL Server Policy-Based Management
Clarification on the "Guest Permissions on User Databases" policy
Posted
over 2 years ago
by
sqlpbm
0
Comments
We ship a "Microsoft Best Practices: Security" policy called " Guest Permissions on User Databases ". Unfortunately, the wording in the UI and BOL is not clear about whether this can/should apply to msdb . Here is what is says today: "You can do...
Page 1 of 1 (4 items)