SQL Server - How to exclude a database RRS feed

  • Question

  • I want to exclude a specific database on a SQL Server 2005 server from being discovered by SCOM 2007 R2.

    The MP guide states:

    You can apply overrides to the following discoveries to specify an “Exclude List” (in comma-delimited format) of database names that the discovery should overlook.

    ·      SQL Server 2008: Discover Databases for a Database Engine

    ·      SQL Server 2005: Discover Databases for a Database Engine

    However I cannot find those discoveries. I only have "Discover SQL Server 2005 Database Engines (Windows Server)" where I can exclude instances. Where can I exclude databases?

    Best regards.
    Wednesday, January 5, 2011 10:35 AM


  • Hi DajoRybski.

    If you scope your Object Discoveries view to only show SQL Server 2005 DB you'll see a discovery called Discover Databases for a Database Engine. Override that on for you databas and then open up a Ops Mgr Shell and run the command Remove-DisabledMonitoringObject and your database should get removed from your console.

    mats.w | www.opsmode.com
    • Marked as answer by Dajo Rybski Wednesday, January 5, 2011 4:32 PM
    Wednesday, January 5, 2011 11:11 AM