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