How to Check whether SQL Instance Clustered or Standalone

Written by

Jugal Shah

in

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’))

Comments

One response to “How to Check whether SQL Instance Clustered or Standalone”

  1. neha sameen Avatar
    neha 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

More posts