Can I use window server backup to backup data of sql anywhere while it's running ?

[former_SQLA_member1694916]

http://dcx.sap.com/sa160/en/dbadmin/da-backup-dbs-5615940.html

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?

[VolkerBarth · Accepted solution]

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.)

[former_SQLA_member1694916 · Accepted solution]

Thank you for your help mate 🙂

[former_SQLA_member1694916 · Accepted solution]

Is vss writer included in the installation of SQL anywhere ?

[chris_keating · Accepted solution]

VSS support was added in V11. See the following documentation reference for more information: http://dcx.sap.com/index.html#sa160/en/dbadmin/vss-database-dbengine.html*d5e17915

[VolkerBarth · Accepted solution]

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

[former_SQLA_member1694916 · Accepted solution]

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

[former_SQLA_member1694916 · Accepted solution]

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

[VolkerBarth · Accepted solution]

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 ...