SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Clustering Questions


SQL Server Clustering Questions

Author
Message
Rajesh kasturi
Rajesh kasturi
Old Hand
Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)

Group: General Forum Members
Points: 341 Visits: 732
Hi,

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

Rajesh Kasturi
Joechelad
Joechelad
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 155
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!!
vivekinmadar
vivekinmadar
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 168
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
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19850 Visits: 17242
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" ;-)
SqlSWAT
SqlSWAT
SSC Journeyman
SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)

Group: General Forum Members
Points: 78 Visits: 454
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..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search