SQL backup or restore operation fails because the timeout interval is reached

Article ID: SQL0008 SQL backup or restore operation fails because the timeout interval is reached while waiting for the job to complete.

Symptom

SQL backup or restore operation fails because the timeout interval is reached.

Cause

SQL backup or restore operation fails because the timeout interval is reached while waiting for the job to complete.

Resolution

To increase the timeout interval for a backup or restore operation:

  1. For the additional setting nSQLQueryTimeout, specify the new Min Value.
  2. Run the operation again.