Property reference

`discovery.mssql.cluster.instance.postsensor.delete`

This property enables the deletion of Microsoft SQL instances related to inactive nodes in a passive cluster. Admins should consider enabling it to remove unnecessary instances and databases during failover, ensuring a cleaner environment.

Default: false Type: boolean Application: Global

Key questions about this property

The answers below summarize the purpose, scope, default effect, and review scenarios for this property.

What does it do?	It allows the system to delete MSSQL instances and related databases from passive cluster nodes after failover, helping to manage resources effectively.
What area does it affect?	MSSQL Cluster Management
What does the default mean?	The default value is "false", which means this behavior is disabled by default.
When should you review it?	Review this property when configuring failover settings or managing SQL cluster resources.

Out of the box property record

Raw metadata from the property record.

Property name	`discovery.mssql.cluster.instance.postsensor.delete`
Sys ID	`c95cb3a4973e9110855cf3771153afff`
Type	boolean
Application	Global
Default value	`false`
Description	Enable Delete MSFT SQL Instance related to inactive node postsensor script which will remove MSSQL instance and related Database from the passive cluster node at the failover.
Updated	2022-12-19 05:30:45

Sources

Official references and nearby text excerpts where this property appears.

Documentation excerpt View supporting context

Context preview Snippet 1

... nodes of the passive cluster changes to Absent. ▪The install status of the nodes of the active cluster changes to Installed. ◦To delete the passive instances and databases, set the discovery.mssql.cluster.instance.postsensor.delete system property to True. Microsoft SQL Server Always On availability groups support Starting from Discovery and Service Mapping Patterns version 1.27.0, the MSSql DB On Windows pattern extension Collect MSSQL ...