Question Re: Trying to do a live backup in Technology Q&A

Trying to do a live backup

Former Member — Fri, 27 Apr 2012 14:15:01 GMT

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.

Re: Trying to do a live backup

Former Member — Fri, 27 Apr 2012 14:22:10 GMT

btw I'm using SQL Anywhere 11

Re: Trying to do a live backup

Former Member — Fri, 27 Apr 2012 14:24:15 GMT

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

Re: Trying to do a live backup

Former Member — Fri, 27 Apr 2012 15:45:54 GMT

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"

Re: Trying to do a live backup

former_SQLA_member1694880 — Sat, 28 Apr 2012 06:08:48 GMT

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

Works for me in V10.

Re: Trying to do a live backup

t1950 — Sat, 28 Apr 2012 12:11:39 GMT

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

Re: Trying to do a live backup

Breck_Carter — Sat, 28 Apr 2012 18:03:36 GMT

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

Re: Trying to do a live backup

VolkerBarth — Sun, 29 Apr 2012 07:36:09 GMT

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.