on 12-14-2013 11:23 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.