Taking the DBA out of a D.R. Test

Question

Taking the DBA out of a D.R. Test

ofg1983

Old Hand

Points: 316
More actions
October 25, 2013 at 1:29 pm

#149990

Guys,
I believe I am putting this up on the correct section, if not, please let me know.
My Question:
What is required in order to take the DBA out of needing to be a part of DR Testing? ( Obvious answers like: dont have any SQL Servers or databases dont count. 🙂 )

Viewing 7 posts - 1 through 6 (of 6 total)

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

ofg1983 (10/25/2013)
Guys,
I believe I am putting this up on the correct section, if not, please let me know.
My Question:
What is required in order to take the DBA out of needing to be a part of DR Testing? ( Obvious answers like: dont have any SQL Servers or databases dont count. 🙂 )

Having documentation or other people who know how to do it?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 2

ofg1983 (10/25/2013)
Guys,
I believe I am putting this up on the correct section, if not, please let me know.
My Question:
What is required in order to take the DBA out of needing to be a part of DR Testing? ( Obvious answers like: dont have any SQL Servers or databases dont count. 🙂 )

Good documentation and a set of tested scripts.... emphasis on the word "tested".

--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)

benjamin.reyes SSCertifiable Points: 5249 More actions · Answer 3

Depends on the type of disaster you are testing for, and what the DBA role means to your organization.

ManicStar SSCoach Points: 17992 More actions · Answer 4

Maybe that's the disaster, the dba is hit by a bus.

Stuart Davies SSCoach Points: 19505 More actions · Answer 5

You would at least need someone who knows what scripts to run in which order.

A junior DBA in other words 🙂

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

george sibbald SSC Guru Points: 104210 More actions · Answer 6

Someone else tasked with performing the DR database work. That means they may not necessarily have written the procedures and\or scripts, but knows where to get hold of them and have performed them under test conditions,with and without a DBA present.

---------------------------------------------------------------------