Hello,

I am getting an error when trying to run dbbackup for a
database that is in use. If I run the same dbbackup command
when no one is accessing it, the backup works.
The command that I am using and the error returned are as
follows:
C:\mydb\backup>dbbackup -y -c "uid=dba;pwd=sql;dsn=MYDB"
backup
Adaptive Server Anywhere Backup Utility Version 9.0.1.2085
Specified database file already in use

This error is returned on several Windows 2003 servers. The
database and sybase are running on the same server where I
am executing the dbbackup. What do I need to change in
order to backup a database while it is in use?

Thanks,
Dave

How is the DSN created? Does the DSN specify the database file name and
attempt to autostart it?

Try specifying the engine name so it can connect to an already running
server if you are not already.

If you still have problems, please post the contents of your DSN.


Dave B wrote:

Thank you for the quick response. The DSN was created as a
system DSN using the ODBC GUI. I tried specifying the local
server in the eng parameter and the result was the same.
The DSN details are:
C:\misdb\backup>dbdsn -gs MISDB
Adaptive Server Anywhere Data Source Utility Version
9.0.1.2085
MISDB:
UID=dba;PWD=sql;DBF=C:\misdb\MISDATA.db;ASTOP=Yes; INT=No

Thanks,
Dave

You first have to resolve what has the file in use. Do you have an
engine already running on this machine?

If so, what is its engine name and database name (the startline would
help us if you are unsure).

-chris



Dave B wrote:

The path to executable listed in the Windows service that
starts the database is:
C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe
-hvASANYs_MISDATA

Is that what you need? The service is configured to run as
the local system account and the option to allow it to
interact with desktop is checked.


Thanks,
Dave

Try adding ENG=MISDATA;DBN=MISDATA; so that dbbackup can connect to a
running database without trying to start it again.

Breck


On 21 Sep 2009 12:09:25 -0700, Dave B wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

This just tells us the name of the service. Try using "dbsvc -g MISDATA"
to display the details about the service.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Dave B wrote: