Script to find if a SQL Server Instance Exist

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 25, 2015 at 4:16 pm

  #316533

  Kindly provide a good script to check if a sql server instance does exist. If not need to throw a good alert. I'm trying using the below script, but taking long time to execute. Any better way to write it, plz suggest

  $instance = "domain\INST4"

  $serverObject = New-Object Microsoft.SqlServer.Management.Smo.Server($instance)

  $instance = $instance.toupper()

  $serverName = $serverObject.ComputerNamePhysicalNetBIOS

  $serverName = $serverName +"\"+$serverObject.InstanceName

  $serverName

  Thanks.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 25, 2015 at 4:35 pm

  #1786435

  My revised script.

  clear-host

  function checkserver

  {

  [CmdletBinding()]

  Param

  (

  [Parameter(Position=0,Mandatory=$true)][string]$instance

  )

  Begin

  {

  $VerbosePreference = 'Continue'

  $DebugPreference = 'stop'

  }

  Process

  {

  $Global:instance= Read-Host "Enter the SQL Service account(SQLSVCACCOUNT) to be used"

  $Global:instance.ToUpper();

  $instance

  $serverObject = New-Object Microsoft.SqlServer.Management.Smo.Server($instance)

  $instance = $instance.toupper()

  $serverName = $serverObject.ComputerNamePhysicalNetBIOS

  $serverName = $serverName +"\"+$serverObject.InstanceName

  #$serverName

  IF ( $serverName -ne "\")

  {

  write-host "Server:" $serverName "exist" -ForegroundColor Green

  }

  ELSEIF ( $serverName -eq "\")

  {

  write-host "Wrong Server name" -ForegroundColor Red

  }

  }

  }

  Thanks.