> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Montag, 11. August 2003 20:04 > To: [EMAIL PROTECTED] > Subject: How can I clear Logvolumes in SAPDB? > > > There are 3 LOGVolume files I like to clear, I was looking in > DBMGUI, but I did not see anywhere. I do have complete SAPDB > backup, I would like to know: > 1) Can I backup these 3 "LOGVolumes" LOG001, LOG002 and > LOG003 (each 4 GB) on a disk, instead of tape? > 2) How can I clear these LOG files? > 3) Is there a way to turn the archive log OFF in SAPDB just > like in Oracle?
With the version 7.3 you have to enable the "demo" Mode. In Version 7.4 you have to enable the "autooverwrite" Mode. Please refer to the documentation how this can be done exactly. Both modes are doing the same. They prevent you from the need of doing log backups. In case of a crash you can restart to a transactional consistent state, but in case of disc failures you will loose all or parts of your data. Using "clear log" or "set log writer off" is not recomended for normal usage. It is only usefull in cases you are sure and knowing what you want to do. kind regards Uwe > Thanks. > ______________________________________________________________ > ________________ > > Regards, > > Raja M. Ahmed > Philips Advance Transformer > 10275 West Higgins Road, > Rosemont, Illinois 60018. > --------------------------------- > (847) 390-5145 > [EMAIL PROTECTED] > --------------------------------- > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
