PowerShell_Scripts icon indicating copy to clipboard operation
PowerShell_Scripts copied to clipboard

strange behaviour in case of multiple instances

Open chipitsine opened this issue 8 years ago • 3 comments

Computername      : SRV-SQL02-DCA
Instance          : {MSSQL$DEV_DCA, MSSQL$HFM_DCA, MSSQL$INF_DCA, MSSQL$IPORT_DCA...}
SqlServer         : SRV-SQL-TFS
WMINamespace      : ComputerManagement12
Sqlstates         : 2099213
Version           : 12.0.2000.8
Splevel           : 0
Clustered         : True
Installpath       : C:\Program Files\Microsoft SQL Server\MSSQL12.WHD\MSSQL
Datapath          : S:\MSSQL12.WHD\MSSQL
Language          : 1033
Fileversion       : 2014.120.2000.8
Vsname            : SRV-SQLWHD-DCA
Regroot           : Software\Microsoft\Microsoft SQL Server\MSSQL12.WHD
Sku               : 1804890536
Skuname           : Enterprise Edition (64-bit)
Instanceid        : MSSQL12.WHD
Startupparameters : -dS:\MSSQL12.WHD\MSSQL\DATA\master.mdf;-eS:\MSSQL12.WHD\MSSQL\Log\ERRORLOG;-lS:\MSSQL12.WHD
                    \MSSQL\DATA\mastlog.ldf
Errorreporting    : False
Dumpdir           : S:\MSSQL12.WHD\MSSQL\LOG\
Sqmreporting      : False
Iswow64           : False
BackupDirectory   : S:\MSSQL12.WHD\MSSQL\Backup
AlwaysOnName      : 
Nodes             : {SRV-SQL01-DCA, SRV-SQL02-DCA, SRV-SQL03-DCB}
Caption           : SQL Server 2014
FullName          : SRV-SQL-TFS\System.Object[]

chipitsine avatar Sep 03 '16 15:09 chipitsine

I think that I had this fixed...but it was at work and that was never updated here. I'll have to see what I did to fix the issue and push it here.

proxb avatar Sep 05 '16 01:09 proxb

Great news!

chipitsine avatar Sep 05 '16 16:09 chipitsine

@proxb Any update on this please ? Also, AlwaysONName is always blank even if AG is configured on the server. Thanks !

TheRockStarDBA avatar Oct 24 '17 16:10 TheRockStarDBA