locked
Exclude a SQL Server instance from Discovery in SQL Server MP RRS feed

  • Question

  • I have found out that we could exclude a SQL Server instance from being discovered by choosing the monitor DISCOVER SQL Server 2008 Database Engines (Windows Server) and choose Exclude list

    My question is what wildcard should i use as string in the Exclude list if i only want to exclude a SQL Server instance with the name er battlespace. The server name is sql-vp14

    Is this the correct wildcard exclusion string: sql-vp14/battlespace ?

    We have many other servers with the same name battlespace so the exlusion need to be specific to the sql server sql-vp14



    mh




    Monday, August 10, 2020 2:50 PM

Answers

  • Hi Morten,

    without being able to test this, I would say Yes, you need to put in the Server\Instance name to achieve this. In general I would recommend you to stay away from the Exclude List for single instances. It would be way better if you just disable the discover of this particular instance. You can just group the instance you don't need (or only this one) and then do this:

    Hope I could help. Regards!


    (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!) Blog: https://blog.pohn.ch/ Twitter: @StoyanChalakov

    Thursday, August 13, 2020 7:01 AM