SQL Server Performance

Database Evacuation Plan

Discussion in 'EditorsBlog' started by shanetasker, Aug 19, 2008.

  1. shanetasker New Member

    In the workplace it is common for the facilities management team to conduct mock evacuations of a building. In some parts of the world it is even mandatory that an evacuation drill occur on a regularly scheduled basis. The point of these drills is to ensure that everybody knows the process to evacuate a building in the event of an emergency and to measure how quickly the building can be emptied.
    When was the last time that you performed a recovery drill for your SQL Server environment to ensure you could recover from a disaster? Just like an evacuation drill, a recovery drill allows you to streamline the efficiency of being able to deal with an emergency. Very rarely will an emergency occur in the middle of the day after you have had a chance to have you morning coffee. From experience, issues will more often than not happen in the early hours of the morning. I used to work with an organization where mock recovery exercises were turned into a friendly rivalry. One DBA would simulate a situation such as a corrupt database and another DBA would need to identify and resolve the situation. If the DBA performing the recovery was unable to resolve the issue he needed to buy the first round of drinks at the pub. How does your organization ensure that each DBA knows what to do in the event of an emergency?
    - Peter Ward

Share This Page