The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

I've been trying to set up and test to see how this live backup thing works and have been having trouble getting to backup utility to run to monitor the log.

I type the following in a command window:

dbbackup -l c:\backup\blog.log -c "uid=dba;pwd=mypswd;eng=mydb;dbn=mydb;links=tcpip"

And all that happens is I get back the usage message. I am able to get a regular full backup to run.

asked 27 Apr '12, 14:15

Brian%20S's gravatar image

Brian S
31223
accept rate: 0%

edited 27 Apr '12, 23:11

Graeme%20Perrow's gravatar image

Graeme Perrow
8.4k369107

btw I'm using SQL Anywhere 11

(27 Apr '12, 14:22) Brian S

Should be ...-l c:backupblog.log ...

(27 Apr '12, 14:24) Brian S

Do you have several instances of SQL Anywhere installed (including very old versions like v5/v6), and may it be that an older dbbackup version may be called incidentally, as it appears earlier in the PATH environment variable? - If so, specifying the SQL Anywhere program path (as Derli has suggested) should resolve the issue.

(29 Apr '12, 07:36) Volker Barth

I am using SA 12 so it may not be exactly your case but can you try using the full path for dbbackup and the -y redirection?

For instance:

"C:\Program Files\SQL Anywhere 12\bin32\dbbackup" -c "UID=xxx;PWD=yyyy;DBN=mydbn;ENG=myeng;LINKS=tcpip;" -y "R:\APPS\DATABASE"

permanent link

answered 27 Apr '12, 15:45

Derli%20Marcochi's gravatar image

Derli Marcochi
1.6k323877
accept rate: 33%

edited 27 Apr '12, 16:14

dbbackup -c "uid=dba;pwd=mypswd;eng=mydb;dbn=mydb;links=tcpip" -l c:\backup\blog.log c:\backup

Works for me in V10.

permanent link

answered 28 Apr '12, 06:08

Dmitri's gravatar image

Dmitri
1.5k41132
accept rate: 11%

Instead of the command line, you can set up events in Sybase Central with a schedule.

permanent link

answered 28 Apr '12, 12:11

Tom%20Mangano's gravatar image

Tom Mangano
587182334
accept rate: 6%

The BACKUP statement cannot be used to start a live backup, only dbbackup can do that.

(28 Apr '12, 18:03) Breck Carter
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:

×71
×9

question asked: 27 Apr '12, 14:15

question was seen: 958 times

last updated: 29 Apr '12, 07:36