Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

DR type Expand / Collapse
Author
Message
Posted Monday, December 21, 2009 3:56 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 29, 2012 5:04 PM
Points: 76, Visits: 619
how many DR types there are? could you name 3 of them?
Post #837623
Posted Monday, December 21, 2009 7:36 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 36,711, Visits: 31,159
Yes 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.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #837693
Posted Monday, December 21, 2009 8:19 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
Jeff is right, and he also answered the list of 3 things you wanted.

Google, Yahoo, Bing.............. Bingo!



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #837706
Posted Thursday, February 4, 2010 9:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:31 PM
Points: 33,051, Visits: 15,159
There's a whole section in BOL on high availability that covers the ways SQL Server handles this.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #860142
Posted Thursday, February 4, 2010 9:11 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
MSDN, Technet and various blogs also have the content.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #860148
Posted Wednesday, February 24, 2010 1:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 6:10 AM
Points: 350, Visits: 429
Hi,

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 afford

Then decide on type of recovery plan that meets your requirement.


- SAMJI
If you marry one they will fight with you, If you marry 2 they will fight for you
Post #871773
Posted Tuesday, March 30, 2010 4:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:54 AM
Points: 1,153, Visits: 4,620
pleasehelpme (12/21/2009)
how many DR types there are? could you name 3 of them?


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=6e67f0911d014d29


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #892586
Posted Wednesday, March 31, 2010 6:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:41 AM
Points: 142, Visits: 1,681
DR 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.]
Post #893672
Posted Thursday, April 1, 2010 1:42 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 3,187, Visits: 2,280
d4mn ?t ...
h0ly sh?t !
4W F?CK !!!




Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #895256
Posted Tuesday, September 6, 2011 8:59 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:24 AM
Points: 952, Visits: 1,156
High availability are also DR types:

1.Clustering
2.Mirroring
3.Log shipping


“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1170486
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse