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

Taking the DBA out of a D.R. Test Expand / Collapse
Author
Message
Posted Friday, October 25, 2013 1:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:51 AM
Points: 4, Visits: 30
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. )

Post #1508582
Posted Friday, October 25, 2013 3:11 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:24 PM
Points: 11,990, Visits: 11,007
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1508609
Posted Friday, October 25, 2013 3:21 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 4:46 PM
Points: 35,959, Visits: 30,250
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." -- 04 August 2013
(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 #1508611
Posted Monday, October 28, 2013 8:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:52 PM
Points: 235, Visits: 1,174
Depends on the type of disaster you are testing for, and what the DBA role means to your organization.
Post #1508928
Posted Monday, March 17, 2014 10:10 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 221, Visits: 1,105
Maybe that's the disaster, the dba is hit by a bus.
Post #1551828
Posted Monday, March 17, 2014 10:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:16 AM
Points: 2,826, Visits: 2,836
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
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
Post #1551833
Posted Monday, March 17, 2014 11:36 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 5,849, Visits: 12,584
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.

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

Post #1551855
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse