Increasing SQL query timeout for Veeam products
Increasing SQL query timeout for Veeam products
It happens sometimes, that the *MsSQL *database server hosting the Veeam Backup&Replication database has poor performances and/or the DB is really huge. Because of this, heavy/big queries can hit the timeout and fail. There is a registry key you can modify to control this time, and the support engineer could ask to increase it.
I think it’s safe to increase it before asking the support, to try solving issues on a very slow or stressed Veeam environments. The key is:
. Name: SqlStatementTimeout
· Type: REG_DWORD
· Value: 18000
· Decimal
Path: HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication\DatabaseConfigurations\MsSql
18000 seconds are 5 hours (!), the default should be 1 hour.