April 17, 2015 at 12:22 am
Could you please some one share Clustering,mirroring and logshipping real time interview questions
April 17, 2015 at 10:40 am
This is very sad...no one there to help me here..no one have interview questions
April 17, 2015 at 1:37 pm
I have not worked with SQL Server HA technologies (clustering, mirroring, replication, Log Shipping) since I was a DBA but I'll give you a few questions and the thinking behind them.
Clustering:
1) Describe a Quorum and why is it necessary for a cluster?
2) How would you simulate a failover?
3) What are some vital Windows services that are used in a Cluster
These are a few basic questions about clustering that would quickly tell you if the candidate knew anything about clustering yet they'd be hard B.S. through. Anyone who has worked with SQL clusters can describe a quorum, explain an event that would have a failover and understand what Windows services are vital...
Mirroring:
I have never done SQL Server mirroring but have used 3rd party tools for mirroring 🙁
Log Shipping:
1) What benefit/advantage does SQL Server log shipping over just creating your own, home-grown solution using a combination of scripts and the SQL agent?
Log shipping is pretty straight forward. This is an uncommon question that I like to ask to get a discussion going. Log shipping does very little that you could not do for yourself but it's easier and faster to get it done via log shipping. It would be hard to answer this question without understanding how log shipping works.
General:
A more important question explain where you would use one HA solution over the other. If someone can answer specific technical questions about any of these technologies but can't answer this question then it looks to me as if they have book knowledge vs strategic/critical-thinking. You don't just want someone who knows HOW to setup log shipping, you want someone who understands why and when you would do so.
That's my 2 cents.
-- Itzik Ben-Gan 2001
April 17, 2015 at 3:34 pm
ask them how they would fail over a mirrored database manually, there are two main commands and hopefully they would say if possible they would ensure the mirroring was in synchronous mode first
---------------------------------------------------------------------
April 20, 2015 at 2:38 am
imsqldba007 (4/17/2015)
Could you please some one share Clustering,mirroring and logshipping real time interview questions
Tell me of a time when you implemented clustering, mirroring or log shipping. What problems did you encounter and how did you work around them?
Interview questions are generally specific to a company, and memorising the answers to them are not a good idea, as you should be honest about what you know and don't know
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2015 at 9:02 am
imsqldba007 (4/17/2015)
Could you please some one share Clustering,mirroring and logshipping real time interview questions
Are you wanting guidance to ask these questions to a potential candidate or brain dump them so you can manipulate yourself into a role which may well be beyond your skillset?
Alan.B (4/17/2015)
1) Describe a Quorum and why is it necessary for a cluster?
Quorum is not an object, it's a state in the cluster that exists and must exist for the cluster to maintain availability.
Witnesses are objects, and I think this is what you were referring too, they take the form of a disk object or a remote fileshare object. However, with the right cluster design neither of these are required to maintain Quorum.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply