Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sybase 5 admin/backup utils?

Posted on 2006-07-21
5
Medium Priority
?
347 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

972 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