Recently, while performing a restore of a SQL DB in Commvault, the restore job failed. The attempt tab of the restore job showed no details and the events tab had the following entry with a timestamp [note the time stamp as it will be handy when reviewing logs].
Received failed message for job [job ID] , phase [Database Restore].
The next step was to login to the SQL client and review the SQLiDA logs. (if the access to the client is not available then right click the Commvault restore job and click on 'view logs' and look for the following section and search for the string 'VD_E_TIMEOUT'
File : SQLiDA.log
Here is how the logs might look:
Received failed message for job [job ID] , phase [Database Restore].
The next step was to login to the SQL client and review the SQLiDA logs. (if the access to the client is not available then right click the Commvault restore job and click on 'view logs' and look for the following section and search for the string 'VD_E_TIMEOUT'
File : SQLiDA.log
Here is how the logs might look:
Solution:
- Restart the commvault services on the client.
- Ensure the client is running the latest service pack (in my case the client had to be updated from V11 SP 9 to V11 SP13)
- Most importantly, follow the Commvault link and apply both the VDI settings (VDI timeout and VDI retry). http://documentation.commvault.com/commvault/v11/article?p=18144.htm
No comments:
Post a Comment