BACKUP

Description

This wait type accumulates while requests are waiting for a backup operation to complete. This is an uncommon wait as SQL Server backups do not block by nature. This wait might occur during backup operations involving databases in the bulk logged recovery model.

Resolved by

DBAs

Suggested solutions

  1. Investigate volume hosting database files, upgrade if possible
  2. Investigate device receiving the backup files, upgrade if possible
  3. Use backup compression if available
  4. Remove any unused indexes (less data to backup)

Additional research

A SQL Server DBA myth a day: Backup Myths
Backup Wait Statistics

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index