disaster recovery 101
TRANSCRIPT
![Page 1: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/1.jpg)
© 2008 Quest Software, Inc. ALL RIGHTS RESERVED.
Disaster Recovery 101
Brent Ozar, Quest Software
![Page 2: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/2.jpg)
Brent Ozar
• SQL Server Expert for
Quest Software
• Former SQL DBA for
$7b company in
Hurricane Alley
• Managed >80tb SAN,
VMware
![Page 3: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/3.jpg)
Today’s Agenda
• HA vs DR– HA Options
– DR Options
• Backup Best
Practices
• Learned the
Hard Way
• Resources
![Page 4: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/4.jpg)
Common Backup Schedules
1. Daily fulls
2. Daily fulls, frequent t-logs
3. Weekly fulls, daily diffs, frequent t-logs
4. “What backups?”
![Page 5: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/5.jpg)
High Availability is for: Disaster Recovery is for:
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/melancon/280076809/
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/meltedplastic/2854777253/
![Page 6: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/6.jpg)
• Replication
• Asynchronous Mirroring
• Log Shipping
• SAN Replication
• Virtualization Replication
High Availability: Disaster Recovery:
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/melancon/280076809/
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/meltedplastic/2854777253/
• Clustering
• Synchronous Mirroring
• Replication
![Page 7: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/7.jpg)
HA: Clustering
![Page 8: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/8.jpg)
HA: Synchronous Mirroring
![Page 9: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/9.jpg)
Both HA, DR: Replication
![Page 10: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/10.jpg)
DR: Asynchronous Mirroring
![Page 11: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/11.jpg)
DR: Log Shipping
![Page 12: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/12.jpg)
DR: SAN Replication
![Page 13: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/13.jpg)
DR: Virtualization Replication
![Page 14: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/14.jpg)
• Replication
• Asynchronous Mirroring
• Log Shipping
• SAN Replication
• Virtualization Replication
High Availability: Disaster Recovery:
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/melancon/280076809/
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/meltedplastic/2854777253/
• Clustering
• Synchronous Mirroring
• Replication
Brent’s Personal Favorites
![Page 15: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/15.jpg)
Backup Best Practices
• Never back up directly to
local disk
• Back up to file share
• Back up to different SAN
• Back flat files up to tape
• Get the tapes offsite fast
• If it’s really critical, mirror
the backups
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/darwinbell/465459020/
![Page 16: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/16.jpg)
Avoid Agents
• Lose schedule control
• Can’t gauge success
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/practicalowl/314989744/
![Page 17: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/17.jpg)
Do Fire Drills Ahead Of Time
• Build a standalone
restore testbed
• Document how
long a restore will
take for managers
• Update it quarterly
• Trust no one
Photo licensed with Creative Commons, used from:
http://www.flickr.com/photos/millzero/705902956/
![Page 18: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/18.jpg)
Tale of Two Bookmark Services
![Page 19: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/19.jpg)
http://delicious.com/brento
![Page 20: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/20.jpg)
Worst Case Scenario
![Page 21: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/21.jpg)
Lessons Learned
• Test your backups
• Retain your backups
• Know business value of backups
![Page 22: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/22.jpg)
Log Shipping Lesson Learned
Production
SQL Server
Production
SQL Arrays
SAN #1 SAN #2
HA
SQL Arrays
High Availability
SQL ServerLog Shipping
![Page 23: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/23.jpg)
Surprise!
Production
SQL Server
Production
SQL Arrays
SAN #1 SAN #2
HA
SQL Arrays
High Availability
SQL ServerLog
Shipping
File Server
Arrays
File
ServerLog
Shipping
![Page 24: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/24.jpg)
Brent’s Role Swap of Doom
Disaster
Recovery
Datacenter
Production
Datacenter100MB connection
Data synced to DR
![Page 25: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/25.jpg)
Brent’s Role Swap of Doom
Disaster
Recovery
Datacenter
Production
Datacenter
100MB connection
Data synced back to production
![Page 26: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/26.jpg)
Brent’s Role Swap of Doom
Disaster
Recovery
Datacenter
Production
Datacenter
100MB connection
Data synced back to production
PLUS
Users running applications that
query the database in DR
1gb Ethernet
![Page 27: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/27.jpg)
Brent’s Role Swap of Doom
Disaster
Recovery
Datacenter
Production
Datacenter
100MB connection
Tape
Jukeboxes
w/10 Drives
Tape
Jukeboxes
w/6 Drives
![Page 28: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/28.jpg)
Building a Bug-Out Bag
Photo Licensed with Creative Commons from http://www.flickr.com/photos/78256324@N00/394214262/
![Page 29: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/29.jpg)
Photo Licensed with Creative Commons from http://www.flickr.com/photos/moflytier/45842386/
![Page 30: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/30.jpg)
Personal Contents
• Power inverter
• Gadget chargers
• Clothes & toiletries
• Water & food
• Insurance papers
• Road atlas
• Flashlight
• Pillow
![Page 31: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/31.jpg)
Work Contents
• Software installs
• License keys
• Cell data card
or Verizon MiFi
• Contact list
(updated annually)
![Page 32: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/32.jpg)
Contact Lists
• Family
• Coworkers
• Managers
• Alternate Offices
• HW Vendors
• SW Vendors
• ISP/Colo
Photo Licensed with Creative Commons from http://www.flickr.com/photos/toastforbrekkie/1237898664/
![Page 33: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/33.jpg)
Lessons Learned
• Trust, but verify
• Test, test, test
• Whiteboard your
environment
• Look for single
points of failure
• Get a bug-out bag
![Page 34: Disaster Recovery 101](https://reader034.vdocuments.us/reader034/viewer/2022052623/559b743c1a28ab6f4f8b4626/html5/thumbnails/34.jpg)
Resources
• Visit our SQL Server technical resource blog
at: www.sqlserverpedia.com - feel free to send
your SQL Server related technical questions to:
• Visit our dedicated SQL Server community
site at: http://sqlserver.quest.com
• Check out our “Backstage” area with all of our collateral and
upcoming events including our „Pain of the Week‟ webcasts:
• www.quest.com/backstage
• www.quest.com/backstage/pow.aspx