Link to home
Start Free TrialLog in
Avatar of Tim Edwards
Tim EdwardsFlag for Canada

asked on

SQL Server unable to backup or create checkpoints on Hyper-V SQLServerWriter Fails

I am not sure what happened but I no longer can back up one of my SQL Servers. We use veeam for our backup product, but I cannot even to a checkpoint in Hyper-V it fails as well.


When I check the vssadmin writers, I see that the SQLServerWriter is failing with the below information:


State: [8]Failed

Last Error: Inconsistent shadow copy


User generated image

Things that I have done so far to try and remedy the situation based on my research:


1. Cycled the the VSS Services - did not fix

2. Full reboot of the server - did not fix

3. Changed logon on the SQLServerWriter from Local System to the local administrator account - did not fix


Avatar of lcohan
lcohan
Flag of Canada image

Do you have the latest VSS updates/fixes installed on the VMs and on Hyper-V Hosts.?

Please have a look at suggestions - options here https://social.technet.microsoft.com/Forums/en-US/606ee8fb-f58c-454d-a695-61158bcb71e7/error-hyperv-vss-writers-inconsistent-shadow-copy?forum=winserverhyperv for a similar issue that you're facing.

Avatar of Tim Edwards

ASKER

Good Morning lcohan,


I can cofirm that the latest vss updates have been applied to both the vm and the hyper-v hosts. 

ASKER CERTIFIED SOLUTION
Avatar of Tim Edwards
Tim Edwards
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial