InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 16:06:24 GMT20http://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxIt's nearly 1 year old thread.Tue, 06 Sep 2011 09:27:06 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxHigh availability are also DR types:1.Clustering2.Mirroring3.Log shippingTue, 06 Sep 2011 08:59:58 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxd4mn ?t ...h0ly sh?t !4W F?CK !!!Thu, 01 Apr 2010 13:42:10 GMTrudy - Doctor "X"http://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxDR Types? - surely "Oops" and "Aaaargh!".Oh, that's two. Better add "Checksum failure"...[Variation on a theme: there are only 11 types of people in the world - those who understand 3-value boolean logic, and those who don't. And the rest.]Wed, 31 Mar 2010 06:03:35 GMTEwan Hampsonhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspx[quote][b]pleasehelpme (12/21/2009)[/b][hr]how many DR types there are? could you name 3 of them?[/quote]Results from google------:-)http://www.google.co.in/#hl=en&ei=mtKxS_idAYL48AbvnbjHAQ&sa=X&oi=spell&resnum=0&ct=result&cd=1&ved=0CAUQBSgA&q=DR+types+sql+server&spell=1&fp=6e67f0911d014d29Tue, 30 Mar 2010 04:34:05 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxHi,If you are not expecting answer to interview question, there are many DR plans. Before deciding on anything you ask yourself• Incase of failure how much data loss can I afford• Incase of failure, how much downtime can I affordThen decide on type of recovery plan that meets your requirement. :cool:Wed, 24 Feb 2010 01:40:52 GMTCOOL_ICEhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxMSDN, Technet and various blogs also have the content.Thu, 04 Feb 2010 21:11:42 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxThere's a whole section in BOL on high availability that covers the ways SQL Server handles this.Thu, 04 Feb 2010 21:03:36 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxJeff is right, and he also answered the list of 3 things you wanted.Google, Yahoo, Bing.............. Bingo! ;-)Mon, 21 Dec 2009 20:19:15 GMTBru Medishettyhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxYes I could... but since this is likely an interview question or homework question and one of the skills a DBA must demonstrate is how to find out answers to questions he/she may not know, I'd recommend you hit Google, Yahoo, and Bing. ;-)Mon, 21 Dec 2009 19:36:42 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic837623-384-1.aspxhow many DR types there are? could you name 3 of them?Mon, 21 Dec 2009 15:56:34 GMTbluepaperbags