Article ID
2047
Product Version
AhsayOBM: 8.1 and above
Operating System
Windows
Symptom
When performing a MS SQL database backup job, the following backup error is received in the backup report:
| No. | Type | Timestamp | Log |
|---|---|---|---|
| info | |||
| * | info | YYYY/MM/DD hh:mm:ss | [Start] Backing up database... |
| erro | |||
| * | erro | YYYY/MM/DD hh:mm:ss |
Cannot start shadow copy, reason=The writer operation failed because of an error that |
Cause
At the same time the following errors appear in Windows Application Event log:
Log Name: Application
Source: VSS
Date: DD/MM/YYYY h:mm:ss
Event ID: 8193
Task Category: None
Level: Error
Keywords: Classic
User: N/A Computer: Computer_name Description:
Volume Shadow Copy Service error: Unexpected error calling routine RegOpenKeyExW(-2147483646,SYSTEM\CurrentControlSet\Services\VSS\Diag,...). hr = 0x80070005, Access is denied.This issue will often occur after installing the DHCP role on the MS SQL server.
Resolution
To resolve the issue, assign Full Control permissions to the Network Service account for the registry key:
- Open Registry Editor from the Windows Start menu.
Browse to:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\Diag
Right clic on Diag, then click Permissions option in the context menu.
Find Network Service in the list and assign the Full Control permissions.
- Click OK, then restart the server afterward.