Results 1 to 6 of 6

Thread: How to apply policy management in SQL server 2008

  1. #1
    Join Date
    May 2009
    Posts
    218

    How to apply policy management in SQL server 2008

    Hi all,

    I am Database administration in one company. I want to create new policies expand the "Management" folder within SQL Server 2008. But in SQL server 2008, It is not define. Can anybody have any idea about how to apply policy management in SQL server 2008. Please help...

  2. #2
    Join Date
    Jan 2008
    Posts
    1,521

    Re: How to apply policy management in SQL server 2008

    You need to defining a policy is to create a condition against the stored procedure. You will need to define all the conditions you might need for all your different policies. To create a new condition right click on the Conditions item and select New Condition. then define your condition name. It is most probably on SP_. After that you need to define an expression. The first step in the process is to select the Field that I need to test. You can do this by clicking on the ellipse next to the Field column in the Expression. Enjoy

  3. #3
    Join Date
    Feb 2008
    Posts
    1,852

    Re: How to apply policy management in SQL server 2008

    There are some new features where added to control your SQL Server instances on SQL server 2008. Policy Management also one new feature of this. It allows you to define rules that report and enforce how your instance can be set up and used. You can manage better role of DBA with the help of policy management in 2008. Each policy identifies a facet in SQL server and condition to identify the rules that the policy is to report. Also a DBA can define how each policy should be applied with help of Policy Management.

  4. #4
    Join Date
    May 2008
    Posts
    2,389

    Re: How to apply policy management in SQL server 2008

    Policy management is anew features in SQL Server 2008 and i found one that looks really interesting. It have many feature like :
    #Target that an entity managed by Policy-Based management like a database, a table, an index, etc.
    # Policy is a condition to be checked and enforced.
    # Facet is a predefined set of properties that can be managed
    # Condition is a property expression that evaluates to True or False.

  5. #5
    Join Date
    Oct 2005
    Posts
    2,393

    Re: How to apply policy management in SQL server 2008

    Policy management is configured in SQL Server Management Studio. You can need to navigate to the Object Explorer and to expand the Management node and the policy management node then you will see the policies, conditions and facets nodes. You also need to expand the facet node to see the list of facets. Just double click on a facet to see the actual list of properties in the facet.This facet properties are used to specify a condition. Policy specifies an expression that evaluates to True or False.

  6. #6
    Join Date
    May 2008
    Posts
    2,297

    Re: How to apply policy management in SQL server 2008

    There are some advantages of apply policy management in SQL server 2008.It gives you much more control over your database procedures as a DBA. You enforce your paper policies at the database level. Paper polices are great for defining database standards are guide lines and it takes time and effort to enforce these. With Policy Based Management, you can also define your policies and rest assured that they will be enforced. If you face any problem please reply.

Similar Threads

  1. Admin account limited by default policy Server 2008
    By superspeed500 in forum Operating Systems
    Replies: 2
    Last Post: 17-10-2011, 01:23 AM
  2. Replies: 1
    Last Post: 05-10-2010, 03:53 AM
  3. Cannot apply Group policy settings on Windows Server
    By Robbin M in forum Active Directory
    Replies: 2
    Last Post: 19-07-2010, 03:41 PM
  4. Password Policy in Server 2008 AD
    By bjude in forum Active Directory
    Replies: 3
    Last Post: 04-02-2010, 03:30 AM
  5. Replies: 1
    Last Post: 08-07-2008, 04:44 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,715,841.18425 seconds with 17 queries