Solved

Sybase 5 admin/backup utils?

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now