We have recently virtualized one of the sites we look after in Hyper-V and ever since we have done this, the event logs are being filled with SQL related backup errors. Nothing seems to break when these errors occur however I would like to get to the bottom of this.
As there are a number of errors, please download the attached event log extract for the entire string. These errors occur exactly every 4 hours without fail.
I have done the following to try and troubleshoot this:
- Checked task scheduler for conflicting schedules, nothing coincides with the timing of these errors
- Checked Backups; Windows backup has been turned off completely as we use Shadowprotect. The Shadowprotect schedule is set to take incremental backups during business hours. These errors happen around the clock.
- Installed SQL server 2008 servicepack 3 and applied all available Windows updates
- Checked VSS Writer health. Intermittently, the majority of writers fail, see attached. Occasionally, all the writers come up as ok. See attached for detail of the writer fails.
- Applied the latest update for our Add2Exchange application that runs on SQL. I also had their support do a once-over on the server to check exchange health etc. Apart from a few changes to permissions to improve security, no problems were found.
- Did some due diligence and ran Google searches on a few of the errors, none of the individual solutions I found seemed to be applicable for this due to the number of different errors and I could find no real info on SQL internal backups as I think the search queries were being skewed by the word backup. I kept getting hits about Windows Backup VSS problems which don't apply here.
- SQL Server 2005 is still installed on this server as the Windows Internal Database seems to run on it. Add2Exchange also seems to rely on this. One post I found suggested I uninstall it but I am not game enough to do this without fully understanding the implications of doing this.
Can you guys please take a look at these logs for me as I am not quiet sure where to go from here.