Solved

Ientify if I am connecting to a SQL server clustered database

Posted on 2012-03-20
3
142 Views
Last Modified: 2012-03-20
Hi,
I am new to SQL clustering.

I have been given a SQL 2008 database which I can connect successfully using SSMS 2008. How I can locate if this is a clustered database? I would prefer a T-SQL stmt.
I have access to the windows box in case that helps.

Thanks
0
Comment
Question by:crazywolf2010
  • 2
3 Comments
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
ID: 37742700
SELECT SERVERPROPERTY('IsClustered')
0
 

Author Comment

by:crazywolf2010
ID: 37742925
Do you have a piece of SQL which will return all attributes of a SQL server cluster?
For example version, cluster configuration, machines in cluster, name of cluster, database created .....
0
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 37743092
SERVERPROPERTY() has several different parameters that will return a list of different things about the server.  Please see Books Online -- or do a Google search for "SQL Server SERVERPROPERTY" -- to get full details on everything SERVERPROPERTY can provide.

Remember, clustering is not part of SQL Server itself.  Typically Windows clustering is used for SQL Server.  (That's the only clustering I'm familiar with, but I think maybe SQL can run under other clustering.)

So clustering details -- # machines in cluster, etc. -- will not be directly available from SQL Server.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sQL pivot 9 39
Selection from table2 where criteria for table1 10 21
Row-Level Security 2 19
Sql query to Stored Procedure 6 15
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now