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: 732 times

last updated: 02 Apr '20, 14:26