cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem with Database backup on VM image

Former Member
2,580

Hi, We have a problem with a client where it seems that a VMware backup occurring during a SQLA backup is causing the backup to completely hang with no generated errors in the event log. We have changed the backup time of our own software just now but to get a definitive answer or just to know if anyone else is experiencing any problems would be useful.

We had a similar problem with another client where you can see the VMware stats collection service running and coinciding with problems happening with users. One is using SQLA 10.0.1.4310 which is due an upgrade soon. The other is on 16.

Is anyone else experiencing problems with backups or general usability on vmware platforms?

The server specs are as follows:

  • 2008 R2 Standard, SP1
  • VMware 5.5 Host (Build 1623387)
  • VMware Tools 8.6.5 (Build 621624)
  • 4 x vCPU
  • 22GB RAM
  • Hard disk 1 - 120GB C: - SSD Storage (DB files)
  • Hard disk 2 - 160GB E: - SAN Storage (DB Backups)
  • Hard Disk 3 - 250GB
  • Hard Disk 4 - 50GB

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

AFAIK, VMware makes use of the Windows VSS service when doing snapshots of Windows VMs. It seems that those snapshots interfere with SQL Anywhere's own backup.

So, when using v16, do you run the SQL Anywhere Volume Shadow Copy Service (VSS) in order to support snapshots of the VM? That tool will issue a CHECKPOINT - and that way prevent (or serialize - I don't know for sure) a parallel backup because that does a CHECKPOINT itself, and checkpoints are serialized.

Cf. that other FAQ: How does SQL Anywhere interact with the Windows Volume Shadow Copy Service (VSS)?


In case the SQL Anywhere Volume Shadow Copy Service helps to solve your problem with v16, note that it has been introduced with v11, so it is not available with v10.

Answers (0)