SQL Server - Check If The Failover Cluster Is Configured Or Not

Mohamed Elqassas Mvp
6y
1.5k
0
2

Blog

In this blog, we will see how to check if the failover cluster is configured or not, using "SERVERPROPERTY".

What's the "SERVERPROPERTY"?

"SERVERPROPERTY" is a System-defined Function used to return the SQL Server Instance Information.

"SERVERPROPERTY" Syntax

SERVERPROPERTY ('propertyname')

ISCLUSTERED

Use ISCLUSTERED property to check if the failover cluster is configured or not.

0	Clustered
1	Not Clustered

Example

declare @IsClustered as sql_variant
set @IsClustered = (select SERVERPROPERTY('IsClustered'))
select @IsClustered as IsClustered ,
case @IsClustered
when 0 then 'Not Clustered'
when 1 then 'Clustered'
else 'Invalid Input'
end as 'IsClustered Status'

Output

Check if the failover cluster is configured or not, using PowerShell?

You can use Windows PowerShell to invoke SQL command on a reachable server within the network using Invoke-Sqlcmd cmdlet, as the following.

Open Windows PowerShell as Administrator
Type the Invoke-Sqlcmd with the below parameters.
- -query: the SQL query that you need to run on the remote server.
- -ServerInstance: the SQL server instance name.
- -Username: the username that has sufficient permission to access and execute SQL query on the remote server.
- -Password: the password of the elevated user.
  
  PS SQLSERVER:\> Invoke-Sqlcmd -query "select SERVERPROPERTY('IsClustered') as 'IsClustered'" -ServerInstance "epm\epmdb" -Username sa -Password *****

Applies To