Solved

Sybase 5 admin/backup utils?

Posted on 2006-07-21
5
343 Views
Last Modified: 2012-05-05
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
Comment
Question by:Moabrocks
  • 4
5 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 17157354
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 17157363
Then you can just do a filecopy or use the MSBackup to backup the file.
0
 

Author Comment

by:Moabrocks
ID: 17170109
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 17170139
That's the way we had to do it forever.  I agree -- clunky, but it works.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17170472
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multiple MSSQL instances on same server 4 55
Help With Simple Database Design 7 57
Database Owner 3 15
Delete old Sharepoint backups 2 15
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question