BACKUP_OPERATOR

Description

This wait type accumulates while the SQL Server is waiting for a tape device to finish mounting. Please note that backing up to tape has been deprecated since 2008. It should not be used for new systems

Resolved by

DBAs

Suggested solutions

  1. Investigate backup device hardware, media and check whether drivers are up to date
  2. Backup databases to disk or file share

Additional research

Deprecated Database Engine Features

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