DR type

Question

DR type

bluepaperbags

SSCommitted

Points: 1738
More actions
December 21, 2009 at 3:56 pm

#215046

how many DR types there are? could you name 3 of them?

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 1

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 2

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.comLearnSQLWithBru

Twitter -- BruMedishetty

Steve Jones - SSC Editor SSC Guru Points: 736458 More actions · Answer 3

There's a whole section in BOL on high availability that covers the ways SQL Server handles this.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

MSDN, Technet and various blogs also have the content.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

COOL_ICE SSCommitted Points: 1706 More actions · Answer 5

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 🙂

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 6

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
https://www.sqlserverblogforum.com/

Ewan Hampson SSCrazy Points: 2780 More actions · Answer 7

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.]

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 8

d4mn ?t ...

h0ly sh?t !

4W F?CK !!!

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 9

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 10

It's nearly 1 year old thread.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/