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.