Home » timeout expired

timeout expired

sql server DBA 999

SQL Server Error : -2 Severity: 0. Timeout expired. The timeout period elap

SQL Server Error : -2 Details

SQL Server Error: -2 Severity: 0 Event Logged or not: No Description: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2). Severity 0 Description: Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.

Solution for Resolving the Error

The query timeout to execute. Either the server is not responding or query is very large/big to execute within timeout limit.

Increase time out in Server properties

 

SQL Server Error Code and solution

Read the rest