Solved

Sybase 5 admin/backup utils?

Posted on 2006-07-21
5
340 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
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…

773 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