Diagnosing and Recovering from Failure by Scenario

Not all issues or failures require recovery. Review the list of documented scenarios to determine whether to initiate the recovery process.

• Database Failure
  Problem: Only the database has failed; the database server and the media are still functioning.
• Hardware Failure: Mirrors Available
  Problem: The storage media or host has failed; no database file nor log file is available. Transaction log mirroring was enabled.
• Hardware Failure: No Mirrors Available
  Problem: The storage media or host has failed; no database file nor log file available. Transaction log mirroring is not enabled.
• Backup Database Is Lost
  Problem: The backup database is lost. While this is not a production failure it does pose a risk.
• Database Corruption
  Problem: You suspect the database is corrupt, and want perform a verification to assess this concern.
• Recovering from Server Node Software Corruption or Host Failure
  Problem: The installed software on a node becomes corrupted or the host computer fails..