search

proxb / PowerShell_Scripts

Miscellaneous scripts for things that I have done; more scripts will arrive as I get time to update this repo.
MIT License
205 stars 72 forks source link

strange behaviour in case of multiple instances #6

Open chipitsine opened 8 years ago

chipitsine commented 8 years ago 
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[]
proxb commented 8 years ago

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.

chipitsine commented 8 years ago

Great news!

TheRockStarDBA commented 6 years ago

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