Voice of the DBA

way0utwest avatar

Common Problems with Backup and Recovery and How to Handle Them

·

way0utwest Avatar
way0utwest

The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we’ll explore the most common problems around SQL Server backup and recovery, so that you can spot any issues in your own environment. Then, we’ll talk about how to prevent these issues in the first place. The foundation of disaster recovery is having a verified backup in place, so the knowledge you’ll gain from this session could help to save your business.

We will look at issues with:

  • file backups
  • disk space
  • backup chain issues
  • full transaction logs
  • off-site storage
  • more

Slides:

SQL in the City – Common Backup Problems SitC_sj.pptx

 

VS Live San Diego

Currently Reading

Reshuffle
My current business book recommended by our CEO
The Current Family Book Club book

administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday Tesla travel vacation windows words work

Comments

One response to “Common Problems with Backup and Recovery and How to Handle Them”

  1. It Still Happens – Full Transaction Log | Voice of the DBA Avatar
    It Still Happens – Full Transaction Log | Voice of the DBA

    […] talked about this recently in my backup talk on the SQL in the City tour stops. Back up your […]

    Like