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.


I am looking for advice on creating Archive backups with ASA 12. The Archive will be stored to a offline storage.


asked 03 Jul '13, 10:07

Lincoln%20Tang's gravatar image

Lincoln Tang
accept rate: 0%

edited 03 Jul '13, 10:20

Mark%20Culp's gravatar image

Mark Culp

The "best practice" for creating archive backups is "don't do it, create image backups instead".

Archive backups date back to Olden Tymes when folks used diskettes, CDs, DVDs, tape drives, zip drives and the like, sometimes FTP. Nowadays, dirt-cheap external hard drives and the cloud rule the offline backup world, with OS file move/copy commands and USB3 and HTTP used to move the files around.

The reason? Nobody should have to start an engine just to run a RESTORE DATABASE command to get your database back... just "start the engine" and have it do automatic recovery of the backup files (db and log).

Plus, all those other storage mediums were notorious for errors, and nobody ever ran verify because it doubles the backup time, meaning they might as well NOT BOTHER taking a backup.

Always run verify during the offline copy, and always run dbvalid on the end result... if dbvalid says your offline copy is OK then you know (by definition) the online database was OK.

permanent link

answered 04 Jul '13, 11:21

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%


I fully second that "best practice" - but who else then Breck could have made the point thaaat clear?

(04 Jul '13, 11:38) Volker Barth

check the SQLA tool dbbackup.exe, you can do full or incremental online backups with no downtime.

permanent link

answered 04 Jul '13, 02:29

Martin's gravatar image

accept rate: 14%


Note that the DBBACKUP tool can create image backups (i.e. copies of the database and/or transaction log files) but it cannot create archive backups (i.a. consisting of only one file containing all database files).

If you really need archive backups (we never had that requirement), you will have to use the BACKUP DATABASE TO <archive> statement.

@Lincoln: If you do know that already, could you please tell what you are actually trying to achieve or what problems do you face?

(04 Jul '13, 03:06) Volker Barth
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: 03 Jul '13, 10:07

question was seen: 2,329 times

last updated: 04 Jul '13, 11:38