SQL server 2008 Question:

Download Job Interview Questions and Answers PDF

What is policy based administration feature of SQL Server 2008?

SQL server 2008 Interview Question
SQL server 2008 Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext Question
What is filestream storage of sql server 2008?Explain Sparse Columns of sql server 2008?