I don't know if this is the right forum for this question, please let me know if it isn't and kindly point me in the right direction. I have just started learning powershell and dbatools.
I am trying to automate uninstalling a SQL Server instance using dbatools. Starting with the following command:
$list = Get-WmiObject -Class Win32_product | Select-DbaObject -Property Name $list.name -cmatch "SQL Server 2019 Database Engine Services".
It returns two entries. My questions:
- There is only one version of SQL Server on the newly built machine, why are two entries returned?
- Is the Engine Service the appropriate service to remove in order to remove all the installed features of the instance at once? $list returns a number of SQL Server 2019 components.