Post reply

Not able to Evaluate policies on Multiple servers PBM SQL 2008

  • November 30, 2009 at 4:32 pm

    #213049

    Im trying to evaluate policies on multiple instances but I'm keep getting "No targets found" message. In my Serverlist condition, selected the following.

    Facet: Server

    Condition: @InstanceName ='InstanceName1'

    OR

    @InstanceName ='InstanceName2'

    Am i doing right? anybody alreay worked on this? Please help me out.

    Thanks

    Jay.

    Thanks
    Jay
    http://www.sqldbops.com

  • December 1, 2009 at 3:28 am

    #1085687

    Possible Errors

    * No targets found

    The target set could be empty due to any of the following reasons:

    o There are no targets on the instance of SQL Server of the type specified by the policy.

    o The server restriction might exclude the instance of SQL Server that contains the target.

    o If the policy is on an object in a database (for example a table, view, or user) the database might not subscribe to the category of the policy.

    o The target-set filter might exclude all targets on this instance of SQL Server.

    o The target server type is different from the server type on which the policy is evaluated. For example, in the Database Engine, if you try to evaluate a policy that has been created for Analysis Services, you will receive an empty target set

    See the MS link:

    Evaluate Policies

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • December 3, 2009 at 1:11 pm

    #1087349

    Thanks for your tip Muthu.

    I'm able to evaluate the policy on multiple instances through registered servers group. Also I'm looking for the purpose of Server facet on Server Restriction column.

    If anybody worked or have examples please update me.

    Thanks

    Jay.

    Thanks
    Jay
    http://www.sqldbops.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply