Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backing up Sybase Anywhere 7 DB

Status
Not open for further replies.

n2nuk

IS-IT--Management
Dec 24, 2002
190
GB
Hi there,

I need to create a backup job to create a local backup to disk that will then back up the file to tape using Backup Exec.

Reading some of the sybase material I have come a number of backup options and am considering online backups as the way to go.

I would welcome advice and suggestions on the following:

What is the preferred backup method used?
What are the downsides to performing a online backup?
Will the log files be flushed when the backup runs?

What are the command line options for setting up the job? I am planning to use scheduled tasks to run a batch file that will perform the backup.

I intend running the following command line to perform an online backup:
dbbackup -c "UID=DBA;PWD=jason;ENG=server;DBN=database" –y D:\dbbkup - will this do the job or are there any switches I may have missed?

Many thanks in advance and apologies for the many questions


I

I would appreciate any views on the best backup method to use. Also appreciate
 
Not sure on the commands but I use a small program called Syncback to do multiple backup locations. It will also zip up your file and ftp it for you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top