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