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

Article ID: 54121

Article Type: Troubleshooting

Last Modified:

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

Symptoms

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

Causes

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.
1 Commvault Way, Tinton Falls, NJ 07724 Sitemap | Legal Notices | Trademarks | Privacy Policy
Copyright © Commvault | All Rights Reserved.