A SQL Server backup or restore operation of a large database fails

Article ID: SQL0014 A SQL backup or restore operation of a large database fails because the backup or restore job cannot finish within the set timeout interval.

Symptom

The SQL Server backup or restore operation of a large database (over 2 TB) fails.

Cause

The SQL Server backup or restore operation of a database over 2 TB fails because the backup or restore operation cannot finish within the specified timeout interval.

Resolution

Procedure

  1. Modify the additional setting nSQLQueryWaitMaxRetryCount by increasing the number of retry counts in the Min Value field.
  2. Run the backup or restore operation again.