Mandate Database Subscription.
How to to easily apply all Policy-Based Management policies in aparticular category to the entire instance of SQL Server 2008, when open the Manage Policy Categories dialog?
A.
select the Mandate Database Subscriptions check box for a category to ensure that all policies in that category are applied to the entire instance.
B.
clear the Mandate Database Subscriptions check box for the CorpPolicies category in the Manage Policy Categories dialog box.
C.
ensure that the Server restriction option for all policies in the CorpPolicies category is set to None.
D.
ensure that the instance of the SQL Server 2008 is specified in the Against targets field for allpolicies in the CorpPolicies.
Explanation:
The Manage Policy Categories dialog box allows you to easily apply all Policy-Based Management policies in aparticular category to the entire instance of SQL Server 2008.
You should select the Mandate DatabaseSubscriptions check box for a category to ensure that all policies in that category are applied to the entireinstance.
When the Mandate Database Subscriptions check box is not selected for a policy category, the policycategory must be applied individually to each relevant portion of the server.
To open the Manage PolicyCategories dialog box, you should perform the following steps:
1. Open SQL Server Management Studio, and expand the Management node in the Object Explorer.
2. Right-click the Policy Management node, and click the Manage Categories option.You should not clear the Mandate Database Subscriptions check box for the CorpPolicies category in the Manage Policy Categories dialog box. When you clear the Mandate Database Subscriptions check box for acategory, the policy category must be applied individually to each relevant portion of the server, which is not whatwas required in this scenario. To manually apply a policy, you can configure the policy with the On demandevaluation mode.
You should not ensure that the Server restriction option for all policies in the CorpPolicies category is set to None . The Server restriction option is used to limit a policy to a subset of the target types. This option isavailable on the General page of the Create New Policy dialog box or the Open Policy dialog box if you open anexisting policy. The Server restriction option cannot be used to apply the policy to the entire instance of the SQLServer 2008.
You should not ensure that the instance of the SQL Server 2008 is specified in the Against targets field for allpolicies in the CorpPolicies category because it is not possible to specify an instance of SQL Server 2008 in the Against targets field. The Against targets field is available on the General page of the Create New Policy dialog box or the Open Policy dialog box if you open an existing policy, and it is used to specify entities of theserver, such as databases.
Objective:
Maintaining SQL Server InstancesSub-Objective:
Implement the declarative management framework (DMF).References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > FeatureReference > SQL Server Management Studio F1 Help > Object Explorer F1 Help > Management Node (ObjectExplorer) > Policy Management Node (Object Explorer) > Manage Policy Categories Dialog Box MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administering Servers by Using Policy-Based Management
