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

asked 18 Aug '16, 07:39

SeanDarling's gravatar image

SeanDarling
61117
accept rate: 0%

edited 18 Aug '16, 07:54

We are also facing similar issue. Was the above issue resolved.

(16 Sep '21, 08:50) Srinath C S
Replies hidden

Yes, the problem was a conflict with VMware snapshots. Making sure the SQLA VSS service was running and making sure that backup times did not conflict fixed both the stuck backup problem and also the DB freezing when VMware did its snapshot. NB, v11 and above only.

(16 Sep '21, 14:53) Justin Willey

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.

permanent link

answered 18 Aug '16, 18:35

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

converted 19 Aug '16, 07:31

Justin%20Willey's gravatar image

Justin Willey
7.6k137179249

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×260
×119
×84
×18
×2

question asked: 18 Aug '16, 07:39

question was seen: 2,060 times

last updated: 16 Sep '21, 14:53