Hello,

I understand that Sybase does not endorse any 3rd party online backup tool. However, I just want to know whether you use any 3rd party tools for online backup and if possible give me some recommendation.

I'm currently using ASA 7, by the way. Thanks.

asked 15 Aug '11, 02:44

ixora's gravatar image

ixora
6114
accept rate: 0%


It is always recommended to backup a running, online database by using the provided backup tools with SQL Anywhere (e.g the 'dbbackup' utility, or 'BACKUP DATABASE' SQL statement, or progammatically through the DBTools API/'DBBackup()'). For more information on designing a backup solution that fits your specific needs, see our whitepaper.

It is generally not recommended to use third-party tools to create backups. The general issue with third-party online backup tools is that they do not understand that an active SQL Anywhere database is comprised of multiple files, in various 'states' that need to be synchronized during a backup. Our built-in tools understand the status of all of these files and can ensure that everything is properly CHECKPOINTed on to disk, before backing the database file up.

If you truly wish to use a third-party backup tool, it is best to shut down the database server first to ensure the database and transaction log are flushed out to disk, to then back up the database as a regular 'file'.


If you're working with VMWare or another OS vitualization utility and are instead taking OS snapshots as a form of 'backup', the above discussion may or may not apply. You should thoroughly test the behaviour of your backups in this environment and ensure that 'restores' are successful.

In all cases, you need to guarantee that all I/O semantics outlined in this whitepaper are met: http://www.sybase.com/detail?id=1092313

permanent link

answered 15 Aug '11, 12:42

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 15 Aug '11, 12:46

As most everyone has already recommended, trying to backup the physical database files with a 3rd party util while running is somewhat likely to create an inconsistent state where your backup will be more likely to run into issues than your live database.

If you are asking about 3rd party utils strictly so you can have an OFF-site backup, what you may wish to do is:

  1. Create a local store for backups
  2. Backup the running database using our backup utility (or statement/api) to the local store
  3. Backup the local store to a remote file backup

Just be sure that (2) and (3) don't run concurrently. That could also put the database into an inconsistent state.

permanent link

answered 15 Aug '11, 14:06

Tyson%20Lewis's gravatar image

Tyson Lewis
2.2k1641
accept rate: 22%

I wonder why you think about a 3rd party tool. I can't imagine any other company being able to create a consistent image of a running db. I'd recommend upgrading to a more recent version of SQL Anywhere. That would give you more control over the backup process while reducing the impact on connected users. See BACKUP-Statement SA12.

permanent link

answered 15 Aug '11, 03:58

Reimer%20Pods's gravatar image

Reimer Pods
4.2k354583
accept rate: 11%

The only proper way to back up a running database is dbbackup utility (or BACKUP DATABASE statement).

permanent link

answered 15 Aug '11, 05:07

Dmitri's gravatar image

Dmitri
1.5k41132
accept rate: 11%

Thank you for your answer, but I'm looking for an online backup tool - a tool that will enable me to backup the database while the database is being actively accessed.

permanent link

answered 15 Aug '11, 03:16

ixora's gravatar image

ixora
6114
accept rate: 0%

2

That tool would be SQL Anywhere. The comand line tool DBBACKUP or the SQL command BACKUP DATABASE can be use to create a live backup. You might also use the DbTools API fur that purpose. Look here for Details: Live Backup

(15 Aug '11, 11:14) Reimer Pods

Thank you everyone for replying. They are very helpful.

permanent link

answered 19 Aug '11, 02:49

ixora's gravatar image

ixora
6114
accept rate: 0%

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:

×72

question asked: 15 Aug '11, 02:44

question was seen: 1,916 times

last updated: 19 Aug '11, 02:49