How to Check whether SQL Instance Clustered or Standalone

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”

neha sameen April 12, 2016 at 5:33 am

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 ↓

aiDeeva.com