Disaster Recovery

1
Disaster Recovery

• Strategies and Options

Half of Small Companies Lack Disaster Recovery
Plan, Says Survey http//readwrite.com/2011/01/12/
half-of-small-companies-lack-disaster-recovery-pla
n
2
Not Being Prepared Means Potential Loss

• Outrages causes financial loss 25,000 per day
• Longer or frequent outages can cause customer
  mistrust
• For many small businesses, loss of data can kill
  the company

• Loss of Customer Trust

Loss of Data

• Customers leave

3
Problem Proposed

• Symantec recently released the results of its
  "2011 SMB Disaster Preparedness Survey"
• 50 of SMBs have no disaster recovery plan
• Others implemented plan due to a loss of data or
  outage
• 65 of them are vulnerable to natural disasters.
• 28 SBMs have tested their recovery plan

4
Types of Failure

• Simple Failure (discussed in Chapter 22)
• Does not affect disk
• Changes in memory may be lost
• RAID/Disk Failure
• Corrupted data due to partial writes
• Geographic Failure
• Flood, Fire, Earthquake, etc.

5
Recovery Strategies

• Types of Backups
• Full Database Backup (ex. Weekly)
• Differential Backups (ex. Daily)
• Transaction Logs (ex. Hourly)

6
Recovery Strategies (cont.)

• Storage of Backup
• Same Disk
• Separate Disk, Same System
• Separate System, Different Location
• On Tape, Remote Facility (e.g. Nuclear Shelter)

7
High Availability

• RAID
• Relication
• Between two systems, or an entire cluster
• Redundant O.S.
• Same transaction runs on both OSs
• Automatic Failure Recovery

8
Recap

• Review what is an acceptable loss
• Find solutions that fit your budget
• Test your recovery solutions often

9
References

• - Oracle Backup and Recovery Strategies
  http//docs.oracle.com/cd/B10500_01/server.920/a96
  519/strategy.htm
• - DB2 Backup and Recovery Strategies
  http//publib.boulder.ibm.com/infocenter/db2luw/v9
  /index.jsp?topic2Fcom.ibm.db2.udb.admin.doc2Fdo
  c2Fc0005945.htm
• - SQL Server Disaster Recovery http//databases.ab
  out.com/od/sqlserver/a/disaster_2.htm
• - Disaster Recovery and Continuity Planning for
  the Database Administrator http//www.datamation.c
  om/netsys/article.php/11075_3765821_2/Disaster-Rec
  overy-and-Continuity-Planning-for-the-Database-Adm
  inistrator---Part-1.htm http//www.datamation.co
  m/netsys/article.php/3767366/Disaster-Recovery-and
  -Continuity-Planning-for-the-Database-Administrato
  r---Part-2.htm
• - Database Disaster Recovery Planning for the
  Unpredictable http//www.mwrutherford.com/portfoli
  o/disasterrecovery/Disaster_Research.pdf
• - Half of Small Companies Lack Disaster Recovery
  Plan, Says Survey
• http//readwrite.com/2011/01/12/half-of-small-comp
  anies-lack-disaster-recovery-plan