Isuues with MS SQL Server Database backup

general discussion
1

Hello,

I have a test environment with a Windows 2x node cluster (Nodes QAWIN2012-7 & QAWIN2012-8) and an additional server (QAWIN2012-9).

All systems are Windows 2012 SR2 with MS SQL 2016 (on the cluster - installed in the cluster / cluster integrated).

I installed your UrServer software on the server QAWIN2012-9 and the UrClient Software on both cluster nodes QAWIN2012-7 & …-8.

In the frontend on the server, I have the normal picture, all looks OK, the clients are listed, both as active.

On the cluster node QAWIN2012-7 I start the “Configure components to backup” and in the mask select the SqlServerWriter part / all databases of the instance and confirm with “OK”:

According to the description I found on your web, the backup of the databases should start immediate (https://www.urbackup.org/backup_mssql.html). However, in my environment is nothing happen. Hours after the configuration was done I have no backups from the client …-7.

If I run on the client in the CMD following command

C:\UrBackupClient>UrBackupClient_cmd.exe start -f -l -c 10.40.12.153

I get the following messages back:

Waiting for server to start backup… done
Timeout while waiting for server to start backup

Can you perhaps help me?

The other question – if I run a backup of a database - in my environment SN16 - from the one server / MS SQL Server Instance, how can I restore the database to another MS SQL Server Instance?

2

Could you post a log of a backup?

Preferably a client-side debug log, but to start even the server side log should give more info.

3

Server side:

2017-07-06 09:09:14: ERROR: backupcom->AddToSnapshotSet(&(Server->ConvertToWchar(selected_vols[i])[0]), GUID_NULL, &additional_refs[i].volid) failed. VSS error code VSS_E_UNEXPECTED_PROVIDER_ERROR
2017-07-06 09:09:14: ERROR: VSS provider information:
2017-07-06 09:09:14: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Helper Provider’
2017-07-06 09:09:14: ERROR: Provider type: Software
2017-07-06 09:09:14: ERROR: Provider Id: {26d02d81-6aac-4275-8504-b9c6edc5261d}
2017-07-06 09:09:14: ERROR: Version: 1.0.0.1
2017-07-06 09:09:14: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Provider’
2017-07-06 09:09:14: ERROR: Provider type: Software
2017-07-06 09:09:14: ERROR: Provider Id: {400a2ff4-5eb1-44b0-8a05-1fcac0bcf9ff}
2017-07-06 09:09:14: ERROR: Version: 1.0.0.1
2017-07-06 09:09:14: ERROR: Provider name: ‘Hyper-V IC Software Shadow Copy Provider’
2017-07-06 09:09:14: ERROR: Provider type: Software
2017-07-06 09:09:14: ERROR: Provider Id: {74600e39-7dc5-4567-a03b-f091d6c7b092}
2017-07-06 09:09:14: ERROR: Version: 1.0.0.0
2017-07-06 09:09:14: ERROR: Provider name: ‘Microsoft File Share Shadow Copy provider’
2017-07-06 09:09:14: ERROR: Provider type: Fileshare
2017-07-06 09:09:14: ERROR: Provider Id: {89300202-3cec-4981-9171-19f59559e0f2}
2017-07-06 09:09:14: ERROR: Version: 1.0.0.1
2017-07-06 09:09:14: ERROR: Provider name: ‘Microsoft Software Shadow Copy provider 1.0’
2017-07-06 09:09:14: ERROR: Provider type: System
2017-07-06 09:09:14: ERROR: Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
2017-07-06 09:09:14: ERROR: Version: 1.0.0.7
2017-07-06 09:09:14: ERROR: Indexing Windows components failed
2017-07-06 09:09:14: ERROR: Constructing of filelist of “qawin2012-8” failed: error - index error
2017-07-06 09:09:15: ERROR: backupcom->AddToSnapshotSet(&(Server->ConvertToWchar(selected_vols[i])[0]), GUID_NULL, &additional_refs[i].volid) failed. VSS error code VSS_E_UNEXPECTED_PROVIDER_ERROR
2017-07-06 09:09:15: ERROR: VSS provider information:
2017-07-06 09:09:15: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Helper Provider’
2017-07-06 09:09:15: ERROR: Provider type: Software
2017-07-06 09:09:15: ERROR: Provider Id: {26d02d81-6aac-4275-8504-b9c6edc5261d}
2017-07-06 09:09:15: ERROR: Version: 1.0.0.1
2017-07-06 09:09:15: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Provider’
2017-07-06 09:09:15: ERROR: Provider type: Software
2017-07-06 09:09:15: ERROR: Provider Id: {400a2ff4-5eb1-44b0-8a05-1fcac0bcf9ff}
2017-07-06 09:09:15: ERROR: Version: 1.0.0.1
2017-07-06 09:09:15: ERROR: Provider name: ‘Hyper-V IC Software Shadow Copy Provider’
2017-07-06 09:09:15: ERROR: Provider type: Software
2017-07-06 09:09:15: ERROR: Provider Id: {74600e39-7dc5-4567-a03b-f091d6c7b092}
2017-07-06 09:09:15: ERROR: Version: 1.0.0.0
2017-07-06 09:09:15: ERROR: Provider name: ‘Microsoft File Share Shadow Copy provider’
2017-07-06 09:09:15: ERROR: Provider type: Fileshare
2017-07-06 09:09:15: ERROR: Provider Id: {89300202-3cec-4981-9171-19f59559e0f2}
2017-07-06 09:09:15: ERROR: Version: 1.0.0.1
2017-07-06 09:09:15: ERROR: Provider name: ‘Microsoft Software Shadow Copy provider 1.0’
2017-07-06 09:09:15: ERROR: Provider type: System
2017-07-06 09:09:15: ERROR: Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
2017-07-06 09:09:15: ERROR: Version: 1.0.0.7
2017-07-06 09:09:15: ERROR: Indexing Windows components failed
2017-07-06 09:09:15: ERROR: Constructing of filelist of “qawin2012-7” failed: error - index error
2017-07-06 09:09:21: ERROR: Backup had an early error. Deleting partial backup.
2017-07-06 09:09:22: WARNING: Exponential backoff: Waiting at least 40m before next file backup
2017-07-06 09:09:23: ERROR: Backup had an early error. Deleting partial backup.
2017-07-06 09:09:24: WARNING: Exponential backoff: Waiting at least 40m before next file backup
2017-07-06 09:10:14: WARNING: Error retrieving last image backup. Doing full image backup instead.
2017-07-06 09:10:15: WARNING: Error retrieving last image backup. Doing full image backup instead.
2017-07-06 09:10:19: ERROR: Request of image backup failed. Reason: Creating shadow copy failed. See client log file for details.
2017-07-06 09:10:19: ERROR: Backup failed
2017-07-06 09:10:20: ERROR: Request of image backup failed. Reason: Creating shadow copy failed. See client log file for details.
2017-07-06 09:10:20: ERROR: Backup failed
2017-07-06 09:10:20: WARNING: Exponential backoff: Waiting at least 40m before next image backup
2017-07-06 09:10:21: WARNING: Exponential backoff: Waiting at least 40m before next image backup

Client side:

2017-07-06 09:08:44: ERROR: backupcom->AddToSnapshotSet(&(Server->ConvertToWchar(selected_vols[i])[0]), GUID_NULL, &additional_refs[i].volid) failed. VSS error code VSS_E_UNEXPECTED_PROVIDER_ERROR
2017-07-06 09:08:44: ERROR: VSS provider information:
2017-07-06 09:08:45: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Helper Provider’
2017-07-06 09:08:45: ERROR: Provider type: Software
2017-07-06 09:08:45: ERROR: Provider Id: {26d02d81-6aac-4275-8504-b9c6edc5261d}
2017-07-06 09:08:45: ERROR: Version: 1.0.0.1
2017-07-06 09:08:45: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Provider’
2017-07-06 09:08:45: ERROR: Provider type: Software
2017-07-06 09:08:45: ERROR: Provider Id: {400a2ff4-5eb1-44b0-8a05-1fcac0bcf9ff}
2017-07-06 09:08:45: ERROR: Version: 1.0.0.1
2017-07-06 09:08:45: ERROR: Provider name: ‘Hyper-V IC Software Shadow Copy Provider’
2017-07-06 09:08:45: ERROR: Provider type: Software
2017-07-06 09:08:45: ERROR: Provider Id: {74600e39-7dc5-4567-a03b-f091d6c7b092}
2017-07-06 09:08:45: ERROR: Version: 1.0.0.0
2017-07-06 09:08:45: ERROR: Provider name: ‘Microsoft File Share Shadow Copy provider’
2017-07-06 09:08:45: ERROR: Provider type: Fileshare
2017-07-06 09:08:45: ERROR: Provider Id: {89300202-3cec-4981-9171-19f59559e0f2}
2017-07-06 09:08:45: ERROR: Version: 1.0.0.1
2017-07-06 09:08:45: ERROR: Provider name: ‘Microsoft Software Shadow Copy provider 1.0’
2017-07-06 09:08:45: ERROR: Provider type: System
2017-07-06 09:08:45: ERROR: Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
2017-07-06 09:08:45: ERROR: Version: 1.0.0.7
2017-07-06 09:08:45: ERROR: Indexing Windows components failed
2017-07-06 09:09:22: ERROR: Recvfrom error in CUDPThread::UdpStep
2017-07-06 09:09:22: ERROR: Last error: 10058
2017-07-06 09:10:11: ERROR: Recvfrom error in CUDPThread::UdpStep
2017-07-06 09:10:11: ERROR: Last error: 10058
2017-07-06 09:10:22: ERROR: Not found
2017-07-06 09:10:26: ERROR: backupcom->AddToSnapshotSet(&(Server->ConvertToWchar(selected_vols[i])[0]), GUID_NULL, &additional_refs[i].volid) failed. VSS error code VSS_E_UNEXPECTED_PROVIDER_ERROR
2017-07-06 09:10:27: ERROR: VSS provider information:
2017-07-06 09:10:27: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Helper Provider’
2017-07-06 09:10:27: ERROR: Provider type: Software
2017-07-06 09:10:27: ERROR: Provider Id: {26d02d81-6aac-4275-8504-b9c6edc5261d}
2017-07-06 09:10:27: ERROR: Version: 1.0.0.1
2017-07-06 09:10:27: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Provider’
2017-07-06 09:10:27: ERROR: Provider type: Software
2017-07-06 09:10:27: ERROR: Provider Id: {400a2ff4-5eb1-44b0-8a05-1fcac0bcf9ff}
2017-07-06 09:10:27: ERROR: Version: 1.0.0.1
2017-07-06 09:10:27: ERROR: Provider name: ‘Hyper-V IC Software Shadow Copy Provider’
2017-07-06 09:10:27: ERROR: Provider type: Software
2017-07-06 09:10:27: ERROR: Provider Id: {74600e39-7dc5-4567-a03b-f091d6c7b092}
2017-07-06 09:10:27: ERROR: Version: 1.0.0.0
2017-07-06 09:10:27: ERROR: Provider name: ‘Microsoft File Share Shadow Copy provider’
2017-07-06 09:10:27: ERROR: Provider type: Fileshare
2017-07-06 09:10:27: ERROR: Provider Id: {89300202-3cec-4981-9171-19f59559e0f2}
2017-07-06 09:10:27: ERROR: Version: 1.0.0.1
2017-07-06 09:10:27: ERROR: Provider name: ‘Microsoft Software Shadow Copy provider 1.0’
2017-07-06 09:10:27: ERROR: Provider type: System
2017-07-06 09:10:27: ERROR: Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
2017-07-06 09:10:27: ERROR: Version: 1.0.0.7
2017-07-06 09:10:27: ERROR: Creating shadowcopy of “C:” failed.
2017-07-06 09:10:27: ERROR: Creating shadow copy failed. See client log file for details.
2017-07-06 09:11:01: ERROR: Recvfrom error in CUDPThread::UdpStep
2017-07-06 09:11:01: ERROR: Last error: 10058
2017-07-06 09:19:50: ERROR: backupcom->AddToSnapshotSet(&(Server->ConvertToWchar(selected_vols[i])[0]), GUID_NULL, &additional_refs[i].volid) failed. VSS error code VSS_E_UNEXPECTED_PROVIDER_ERROR
2017-07-06 09:19:50: ERROR: VSS provider information:
2017-07-06 09:19:50: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Helper Provider’
2017-07-06 09:19:50: ERROR: Provider type: Software
2017-07-06 09:19:50: ERROR: Provider Id: {26d02d81-6aac-4275-8504-b9c6edc5261d}
2017-07-06 09:19:50: ERROR: Version: 1.0.0.1
2017-07-06 09:19:50: ERROR: Provider name: ‘Microsoft CSV Shadow Copy Provider’
2017-07-06 09:19:50: ERROR: Provider type: Software
2017-07-06 09:19:50: ERROR: Provider Id: {400a2ff4-5eb1-44b0-8a05-1fcac0bcf9ff}
2017-07-06 09:19:50: ERROR: Version: 1.0.0.1
2017-07-06 09:19:50: ERROR: Provider name: ‘Hyper-V IC Software Shadow Copy Provider’
2017-07-06 09:19:50: ERROR: Provider type: Software
2017-07-06 09:19:50: ERROR: Provider Id: {74600e39-7dc5-4567-a03b-f091d6c7b092}
2017-07-06 09:19:50: ERROR: Version: 1.0.0.0
2017-07-06 09:19:50: ERROR: Provider name: ‘Microsoft File Share Shadow Copy provider’
2017-07-06 09:19:50: ERROR: Provider type: Fileshare
2017-07-06 09:19:50: ERROR: Provider Id: {89300202-3cec-4981-9171-19f59559e0f2}
2017-07-06 09:19:50: ERROR: Version: 1.0.0.1
2017-07-06 09:19:50: ERROR: Provider name: ‘Microsoft Software Shadow Copy provider 1.0’
2017-07-06 09:19:50: ERROR: Provider type: System
2017-07-06 09:19:50: ERROR: Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
2017-07-06 09:19:50: ERROR: Version: 1.0.0.7
2017-07-06 09:19:50: ERROR: Indexing Windows components failed
2017-07-06 09:57:06: ERROR: Not found

4

On a next try with server V. 2.2.2 Beta & Client 2.2.1 Beta both on one server with MS SQL 2016 installed again the following messages in the log:

Fehler

06.07.17 14:34 backupcom->AddToSnapshotSet(&(Server->ConvertToWchar(selected_vols[i])[0]), GUID_NULL, &additional_refs[i].volid) failed. VSS error code VSS_E_UNEXPECTED_PROVIDER_ERROR
Fehler

06.07.17 14:34 VSS provider information:
Fehler

06.07.17 14:34 Provider name: ‘Hyper-V IC Software Shadow Copy Provider’
Fehler

06.07.17 14:34 Provider type: Software
Fehler

06.07.17 14:34 Provider Id: {74600e39-7dc5-4567-a03b-f091d6c7b092}
Fehler

06.07.17 14:34 Version: 1.0.0.0
Fehler

06.07.17 14:34 Provider name: ‘Microsoft File Share Shadow Copy provider’
Fehler

06.07.17 14:34 Provider type: Fileshare
Fehler

06.07.17 14:34 Provider Id: {89300202-3cec-4981-9171-19f59559e0f2}
Fehler

06.07.17 14:34 Version: 1.0.0.1
Fehler

06.07.17 14:34 Provider name: ‘Microsoft Software Shadow Copy provider 1.0’
Fehler

06.07.17 14:34 Provider type: System
Fehler

06.07.17 14:34 Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
Fehler

06.07.17 14:34 Version: 1.0.0.7
Fehler

06.07.17 14:34 Indexing Windows components failed
Fehler

06.07.17 14:34 Constructing of filelist of “qawin2012-9” failed: error - index error
Fehler

06.07.17 14:34 Backup had an early error. Deleting partial backup.

5

Windows cannot create snapshots. Look at e.g. the Windows event log for details.

6

Thank you, looks really like this, in the Event Viewer I have:

Volume Shadow Copy Service error: A critical component required by the Volume Shadow Copy service is not registered.
This might happened if an error occurred during Windows setup or during installation of a Shadow Copy provider.
The error returned from CoCreateInstance on class with CLSID {3e02620c-e180-44f3-b154-2473646e4cb8} and
Name SW_PROV is [0x80040154, Class not registered].

Operation:
Obtain a callable interface for this provider
Add a Volume to a Shadow Copy Set

Context:
Provider ID: {74600e39-7dc5-4567-a03b-f091d6c7b092}
Class ID: {3e02620c-e180-44f3-b154-2473646e4cb8}
Snapshot Context: 4194313
Execution Context: Coordinator

But if I try to “Create Shadow” on the same C: & J: Volumes with the help of vssadmin, it works:

C:\Users\Administrator.QS>vssadmin Create Shadow /For=C: /AutoRetry=2
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
© Copyright 2001-2013 Microsoft Corp.

Successfully created shadow copy for ‘C:’
Shadow Copy ID: {59d6d513-94c8-4f4d-beb6-2e119d57b003}
Shadow Copy Volume Name: \?\GLOBALROOT\Device\HarddiskVolumeShadowCopy1

C:\Users\Administrator.QS>vssadmin Create Shadow /For=J: /AutoRetry=2
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
© Copyright 2001-2013 Microsoft Corp.

Successfully created shadow copy for ‘J:’
Shadow Copy ID: {c8331624-eab3-40b9-889e-3473ff7f365d}
Shadow Copy Volume Name: \?\GLOBALROOT\Device\HarddiskVolumeShadowCopy2

7

Did you solve this problem? When I started backing up a couple of windows servers a few days ago, I also got “VSS_E_UNEXPECTED_PROVIDER_ERROR”. Googling this suggested that another software using shadow copies (in my case BackupExec) might have registered their own vss provider, but “vssadmin list providers” only returned windows’ own ones. When restarting the vss and urbackupclientbackend services and stopping backupexec did not help, I tried restarting the server and then urbackup was able to create shadow copies.