Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

In this link it's written than "In rare circumstances, SQL Anywhere might be unable to suspend transactions or complete a checkpoint within the maximum time allowed by VSS. If this occurs, you must use the transaction log file and the full recovery process to recover the backed up database. " so is it safe to backup data of sql anywhere server while it's running ? and what is full recover process in SQL anywhere if above mention scenario occurs?

asked 01 Apr '20, 05:38

hg1735's gravatar image

accept rate: 0%

edited 02 Apr '20, 14:26

See that similar question here with John's thorough answer. I guess that should answer your question, too, particularly the last paragraph of that answer.

(Aside: You used "live-backup" as tag but a live backup is something different within SQL Anywhere, namely a client-side continuous backup process. What you are looking for is simply a backup of a running database via VSS.)

permanent link

answered 01 Apr '20, 06:02

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 01 Apr '20, 06:04

Thank you for your help mate :)

(01 Apr '20, 06:34) hg1735

Is vss writer included in the installation of SQL anywhere ?

(01 Apr '20, 14:50) hg1735

VSS support was added in V11. See the following documentation reference for more information:*d5e17915

(01 Apr '20, 22:43) Chris Keating
Replies hidden

Just to add: If your database server runs as service, you might also let the dbvss tool run as service, see here for Windows.

(02 Apr '20, 02:52) Volker Barth

So first I have to add a new service for vss write by dbsvc using dbvss17 executable right ?

(02 Apr '20, 04:59) hg1735

"dbsvc -a username -p password -w NewServiceName dbvss17 " I'm using this command to create a vss writer is it right ?

(02 Apr '20, 05:03) hg1735
Replies hidden

AFAIK, you must add the "-t DBVSS" switch to add a DBVSS service (the default would be a personal database engine service), and you might add "-rs ..." to start that DBVSS service after the database network server service...

As to the account used, you might also use -as instead of -a ...

(02 Apr '20, 08:13) Volker Barth
showing 5 of 7 show all flat view
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 01 Apr '20, 05:38

question was seen: 832 times

last updated: 02 Apr '20, 14:26