How to Check whether SQL Instance Clustered or Standalone

1 Reply

You can check the SQL Server is cluster or standalone using one of the below technique.

Technique 1: Go to server properties from SSMS and check the Is Clustered property.

 

 

Technique 2: Execute the below query, it will retun Boolean value. (1 = True and 0=False)

SELECT
CONVERT(char(20),
SERVERPROPERTY(‘IsClustered’))

1 thought on “How to Check whether SQL Instance Clustered or Standalone”

  1. neha sameen's avatarneha sameen

    hI,

    i have tried the 2nd technique. but it throwing the error. please help me to how to check db is standalone or not?

    Reply ↓

Thanks for the comment, will get back to you soon... Jugal Shah