SQL Server Clustering Questions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » SQL Server Clustering Questions

SQL Server Clustering Questions

Rate Topic

Display Mode

Topic Options

Author

Message

Rajesh kasturi

Posted Thursday, March 03, 2011 11:50 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:26 PM
Points: 185, Visits: 725

Hi,

Can someone provide few important interview questions on clustering with answers?

Rajesh Kasturi

Post #1072773

Joechelad

Posted Friday, January 25, 2013 2:38 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 4, Visits: 99

1.What is clustering?
2.How many IP addresses are required to configure a 2 node cluster?
3.What are the requirements to install a SQL server cluster?

these are some questions that I would ask in an interview for a start!!
good luck with the answers!!

Post #1411935

vivekinmadar

Posted Sunday, January 27, 2013 10:57 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 2:30 AM
Points: 24, Visits: 143

Hi Raj

1) What is cluster service ?
2) What is quorum ?
3)What are types of quorum ?
4) What you means private and public network ?
5) What is difference between install SQL server 2005 and SQL server 2008
6) What is difference between the troubleshooting in SQL server 2005 and SQL Server 2008 while installation .
7) How is internal behavior of SQL server 2005 and SQl server 2008
8)What is means of Virtual IP Address and Virtual Name
9) Max number of instance instance in SQL server 2005 and 2008
10) Service pack applying in SQl server 2005 and 2008
11)How internal structure of Quorum?
12)Why is means by MSDTC and It is mandatory for sql server 2005 and 2008
13)How you validating the SQL Cluster ?
14) If your cluadmin is not working then how you validating the whether your resources are online or not
15) What means by prepared owner and possible owner ?
16) What are ip address required when you installing 3 node cluster with 2 instance

Post #1412185

Perry Whittle

Posted Monday, January 28, 2013 5:10 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204, Visits: 11,165

Shouldn't you be actually gaining the required knowledge rather than brain dumping a few answers. No doubt if you do manage to land the role any support you require will be gained form this site and others like it Whistling

If you really want to under clusters and SQL Server, follow my guide at these links for more info

Part1
Part2
Part3

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1412355

SqlSWAT

Posted Tuesday, January 29, 2013 1:15 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:09 PM
Points: 38, Visits: 337

Hi
Recently I was asked lots of questions on SQL Failover Clustering.
Like :
1. What is the difference between Active/Active , Active/Passive Clustering.
2. What are the main things to be considered while setting up a Failover Clustering.
3. Give a real life scenario when you had a problem/issue with Failover Clustering and how did you tackle it.
4. What is your best achievement on administering Failover Clustering in your DBA life.

Prepare to give them the real life example that you had faced before. If you have already forgotten it , this will be the time to practice again. It is not very difficult to setup and practice this High Availability on a local VM Machine. I would encourage you to be more practical and test it on some test VM pcs.
Hope this will help..

Post #1413297

« Prev Topic | Next Topic »

Permissions