PowerShell_Scripts
PowerShell_Scripts copied to clipboard
strange behaviour in case of multiple instances
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[]
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.
Great news!
@proxb Any update on this please ? Also, AlwaysONName is always blank even if AG is configured on the server. Thanks !