Database Reference
In-Depth Information
12. To create a new category, click in the Name field on the last row and type in the name
for the category. Enter a name as Administer Database the category and under Text
to display as This category must be used on all the databases of SQL Server.
As the condition and policy is created, it is essential to evaluate the newly created policy to
determine which of your servers and databases are out of compliance. The policy evaluation
can be leveraged using the following methods:
1.
Right-click on a server instance, server object, database, or database object in SQL
Server Management Studio and select Policies and then Evaluate.
2.
Expand the Management folder, then expand the Policy Management folder, and
right-click on Policies and select Evaluate.
3.
On the Evaluate policies page, check the policy and click the Evaluate button.
4.
The Evaluation results pane will display the servers where the policy has failed under
target details. Click the View hyperlink, which will allow us to browse and get more
details on why that individual target server and policy target failed.
This completes the steps to implementing and administering policy-based management.
 
Search WWH ::




Custom Search