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

  1. 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

Leave a Reply to neha sameen Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s