• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

Sybase 5 admin/backup utils?

I have discovered a legacy document handling app within a split organization that unfortunately for me is still required by data mining/report entry.  It is a Sybase SQLanywhere 5x engine running on a XP box with the document apps running on some client apps connecting to two different .db's back on the Sybase machine.  Sybase needs the local admin account logged in to start the 2 db processes in open windows for the client ODBC connections.  My problem is that I need to automate either online backups or shutting down the 2 windows, starting a file copy batch job, and restart the 2 windows.  There doesn't seem to be any backup utility embedded within Sybase/SQLanywhere.

Can anyone make any recommendations?
0
Moabrocks
Asked:
Moabrocks
  • 4
1 Solution
 
Jim P.Commented:
There should be a quitting time flag (-qt flag) available when you start the database by whatever method.

Then you set up in a scheduled task to run a batch job to start the database in the morning.
0
 
Jim P.Commented:
Then you can just do a filecopy or use the MSBackup to backup the file.
0
 
MoabrocksAuthor Commented:
thanks Jimpen..

okay, I figured out the flag,,  which is '-tq' not '-qt' for whatever reason.  so this method will work, just a little clunky.. (a little, I'm sure this will suffice).

can anyone tell me why the dbbackup util I found in the sqlany50/win32 directory doesn't seem to work?  When I tested the utility against a file copy of the db, I ran it as such "dbbackup \test\db"  which prompted "db directory doesn't exist, create?" which I replied 'Y', the utility created the directory \temp\db but did not look into the file \temp\db.db and back anything up?

0
 
Jim P.Commented:
That's the way we had to do it forever.  I agree -- clunky, but it works.
0
 
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now