cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase SQL anywhere database backup

Former Member
0 Kudos
937


Dear Expets,

I am using BI 4.1 sp1 BOBJ server under sybase SQL anywhere 12 database  and Operating system is Windows 2008 server.

I want to take offline and online backup of database , How to take from both command line and from admin console ( please guide me step by step procedure I am first time using SQL aynwhere database).

second My SQl server database consist 4 files

1.  BI4_Aduit.db          Size of this file is       1025 MB

2. BI4_Audit.log           Size of this file is       924 MB

3.  BI4_CMS.db          Size of this file is        47 MB

4. BI4_CMS.log          Size of this file is        3.4 GB

why BI4_CMS.log  size too much how to reduce the CMS log file size

Regards

Accepted Solutions (1)

Accepted Solutions (1)

jeff_albion
Advisor
Advisor
0 Kudos

Hi Shahid,


I am using BI 4.1 sp1 BOBJ server under sybase SQL anywhere 12 database  and Operating system is Windows 2008 server. I want to take offline and online backup of database

Please see the document posted by José Ramos on this topic in the BI area: http://scn.sap.com/docs/DOC-48608 - this should get you started. Feel free to post back here if you have any questions.


why BI4_CMS.log  size too much how to reduce the CMS log file size

The BI4_CMS.log file is the transaction log file used by SQL Anywhere, which keeps track of all data changes in the database and is used for recovery purposes. It will constantly grow as more activity occurs on the database server over time.

To control the size of the transaction log, you should either truncate or rename the tranasaction log as part of your backup process.

Regards,

Jeff Albion

SAP Active Global Support

Answers (1)

Answers (1)

JasonHinsperger
Advisor
Advisor
0 Kudos

Offline backups (when the database server is stopped) can be done using a simple file copy of the *.db and *.log files.

Online backups can be done using the dbbackup.exe utility that ships with SQL Anywhere, or by using the SQL BACKUP statement. There is also a backup wizard in Sybase Central (the database administration tool)

You can read all about backup including examples, how to automate them, etc... here:

http://dcx.sybase.com/index.html#sa160/en/dbadmin/da-new-backup.html*d5e63772

--Jason Hinsperger

Product Manager

SAP