MS SQL database migration: Timeout expired

Refers to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows
  • Plesk 9.x and below for Windows

Created:

2016-11-16 13:19:12 UTC

Modified:

2016-12-21 20:26:52 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MS SQL database migration: Timeout expired

Symptoms

The source: Plesk 8.x for Windows with remote MS SQL server.
The destination: Plesk 11.x/12.x with local MS SQL server.
A domain with large MS SQL database (like 2G) should be migrated.

The migration is finished with the error:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Cause

Remote login timeout of MS SQL server is expired. It is configured to 20 seconds by default.

Resolution

Change 'Remote login timeout' to 300 seconds using Microsoft SQL Server Management Studio. For this click right mouse button on the SQL Server instance > Properties > Advanced > Network .

Or use the following cmd.exe command line:

osql.exe -E -Q "EXEC sp_configure 'remote login timeout', 300 ; RECONFIGURE;"

Timeout value can be increased even more if 300 seconds is not enough to resolve the issue.

Have more questions? Submit a request
Please sign in to leave a comment.