Ehbit ninja's blog

Our IT ninja's blog about their professional experiences with IT technologies

7 Preventable Backup Errors

Grant Fritchey wrote a blog on some common errors in SQL Backups.

the 7 errors he describes are:

  • File Backups:
    .MDF and .LDF files have been backed up
  • Drive Space:
    the error message “Insufficient disk space for backup” or some similar message occurs
  • Transaction Log is Full:
    alert that a transaction cannot complete because there is insufficient space in the log
  • Backing Up Across the Network:
    backups are running so slowly that sometimes you get timeout errors and the logs fail
  • Only Have Differential Backups Available:
    error: The log or differential backup cannot be restored because no files are ready to roll forward
  • Breaking the Backup Chain:
    error: This differential backup cannot be restored because the database has not been restored to the correct earlier state
  • Restoring to the Wrong Server:
    this isn’t a backup issue per se, but it is an extremely common event

Original blog post: 7 Preventable Backup Errors