InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:18:21 GMT20http://www.sqlservercentral.com/Forums/Topic1072773-1549-1.aspxHiRecently 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..Tue, 29 Jan 2013 13:15:13 GMTSqlSWAThttp://www.sqlservercentral.com/Forums/Topic1072773-1549-1.aspxShouldn'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[url=http://www.sqlservercentral.com/articles/virtual/72682/][u][b]Part1[/b][/u][/url][url=http://www.sqlservercentral.com/articles/Clustering/73989/][u][b]Part2[/b][/u][/url][url=http://www.sqlservercentral.com/articles/Clustering/73994/][u][b]Part3[/b][/u][/url]Mon, 28 Jan 2013 05:10:47 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1072773-1549-1.aspxHi 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 20086) 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 20088)What is means of Virtual IP Address and Virtual Name9) Max number of instance instance in SQL server 2005 and 200810) 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 not15) What means by prepared owner and possible owner ?16) What are ip address required when you installing 3 node cluster with 2 instance Sun, 27 Jan 2013 22:57:38 GMTvivekinmadarhttp://www.sqlservercentral.com/Forums/Topic1072773-1549-1.aspx1.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!!Fri, 25 Jan 2013 14:38:41 GMTJoecheladhttp://www.sqlservercentral.com/Forums/Topic1072773-1549-1.aspxHi,Can someone provide few important interview questions on clustering with answers?Thu, 03 Mar 2011 11:50:07 GMTRajesh kasturi