RE: Log

[Tilo Heinrich]

Hello Dusan,

you could either force SAP DB to overwrite its log volume as needed, thereby avoiding the
need for log backups and increasing the risk of data loss in case of disk problems or you
could deactivate write operations on the log volume at all, thereby avoiding the need for
log backups, increasing performance and loosing data due to restarting the database.

You can change both setting using DBMGUI->Configuration->Log Settings->Next. The
first case can be configured through the "Overwrite Mode for the Log Area", the second
through "Activating or Deactivating Redo Log Management".

Best Regards,
Tilo Heinrich
SAP Labs Berlin

-----Original Message-----
From: Dusan Kolesar [mailto:dusankolesar@stripped]
Sent: Tuesday, February 03, 2004 2:31 PM
To: Heinrich, Tilo
Cc: SAP DB mailing list
Subject: Re: Log


On Tue, 3 Feb 2004 10:40:21 +0100, Heinrich, Tilo <tilo.heinrich@stripped> 
wrote:

> What database version and which administration tool are you using?
>
> Best Regards,
> Tilo Heinrich
> SAP Labs Berlin
>
> -----Original Message-----
> From: Dusan Kolesar [mailto:dusankolesar@stripped]
> Sent: Tuesday, January 27, 2004 3:04 PM
> To: SAP DB mailing list
> Subject: Log
>
>
> Hello,
>
> Is it posible turn off log?
> And how to delete existing log.
>
> Thank you
> Dusan
>

I use SAP DB version 7.4.3 on Windows XP.
For administrating I use DB Manager GUI.

Dusan