SQL server 2008 Question:

What is policy based administration feature of SQL Server 2008?

Tweet Share WhatsApp

Answer:

Policy based database administration allows the DBA for managing the instances and objects of SQL Server 2008 across the enterprise by a defined policies that are set. These policies are the rules and regulations which determine the possible ways of what to do and what not to do and the way the violations of policies are enforced and reported. The policies are well defined by using facets and conditions.

Facet: An object which contains the properties which well describes a component.

Condition: A logical expression that is defined on a facet. It is used for identification of acceptable property values of the facet.

Download SQL server 2008 PDF Read All 26 SQL server 2008 Questions
Previous QuestionNext Question
What is filestream storage of sql server 2008?Explain Sparse Columns of sql server 2008?