When disaster strikes you have to respond and get things fixed ASAP. However if you could turn back the clock, and think about the potential problems and possible issues, can you decrease the time it takes to get things back to normal?

This presentation looks at reducing your RTO by examining four common disasters, of which most disasters are a variation. We examine the components of RTO and then how you can reduce each one of them with a little forethought and preparation. The disasters are

• Hardware Failure
• User (or DBA) error
• Corruption
• Bad Deployment

The talk includes a few demos of how you can respond quicker using Red Gate tools.

Level: 100

Length: 60 minutes

Slides: Available after the SQL in the City 2012 tour.