1
Vote

Error: Timeout expired.

description

Mitchel,

I hope you are doing well. When manually running the job to shrink the database, I am seeing the following fairly quickly after initiation.

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

Any ideas?

Thanks,

David

comments

tadnor wrote Sep 23, 2014 at 11:45 AM

Probably your query takes more than 30 sec. to finish.

My solution was to get the source code and change it so it could use SQLCommand with timeout = 600 sec. (10 minutes) instead of SQLHelper and rebuild dll.