Tuesday, 14 July 2015

Compare hotfix

f you have 2 node SQL Cluster or mirroring, may need to check all the servers are on same windows hotfix or not. There is an easy way to check it in PowerShell.
If both Servers are on same hotfix then there will no output. If not it will show which KB is missing on which Server.
**You must have Sysadmin privilege to the SQL server.

$node1 = gwmi win32_quickfixEngineering  -ComputerName Server1
$node2 = gwmi win32_quickfixEngineering  -ComputerName Server2
Compare-Object -ReferenceObject $node1 -DifferenceObject $node2 -Property HotFixId

No comments:

Post a Comment