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

Advertisements

One 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

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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s