You can change the SQL Server Virtual Device Interface (VDI) timeout setting if you determine that the SQL database was not successfully backed up or restored.
VDI is an API used to communicate with a SQL Server during all backup and restore operations. The VDI timeout interval is the length of time the system waits for the SQL Server to respond to the backup or restore requests.
During a backup or a restore operation, by default, Commvault waits 300 seconds in the first attempt. For each subsequent attempt made by the software, five minutes is added to the previous attempt time for the SQL Server to respond to a VDI command. If the timeout period has elapsed before the operation is completed, Commvault assumes that the command has failed, and it aborts the operation.
The Commvault software retries the connection to VDI 3 times, by default.
Before You Begin
-
Optional: Change the number of retries when there is a VDI timeout.
- To change the number of retries for a client, or client group, to the SQL client or SQL client group, add the dwCVMSSQL_VDI_TIMEOUT_RETRY_COUNT additional setting as shown in the following table.
For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.
|
Property |
Value |
|---|---|
|
Name |
|
|
Category |
MSSQLAgent |
|
Type |
Integer |
|
Value |
The number of retries. Valid values are 3-20. |
- To change the number of retries for all SQL clients, run the qcommand execscript command with the CVMSSQL_VDI_TIMEOUT_RETRY_COUNT parameter.
Procedure
-
From the CommCell Browser, click Client Computers > client > SQL Server.
-
Right-click the instance, and then click Properties.
The Properties of SQL Server dialog box is displayed.
-
On the General tab, type or select a value in the VDI Timeout box, and then click OK.