How to disable the archive logs in SAP IDES(Windows) using SQL Server

[Former Member]

can any body tell us How to disable the archive logs in SAP IDES(Windows 2003) using SQL Server 2000.SP4.?

[Former Member]

Hi,

Try to shrink the database logs to prefered size using the following T-SQL commands through SQL Manager/SQL Studio.

1. BACKUP LOG<SID> WITH TRUNCATE ONLY

2. DBCC SHRINKFILE(transaction_log_name(SIDLOG1),4000)

Regards

Rayees Palot

[Former Member]

Hi,

There is no Archive log concept in MSSQL DB, this was in Oracle. If you mean Log in SQL, you cannot disable the log , even if you detach the DB will not startup without LOG file available.

If you feel LOG file taking lot of space, you can shrink file in regular intervel or you can set Log to simple as Dibya suggested.

Regards....

[Former Member]

Hi,

Unfortunately, SQL Server does not have the option to turn off transaction logging. You can set the recovery mode to SIMPLE, instead of FULL. This will result in the transaction log being truncated on checkpoint.

http://support.microsoft.com/kb/873235 - check this microsoft article

This will help in reduction of the size of the transcation log.

- Regards, Dibya

[Former Member]

Hi,

SQL Server doe not create or use Archive Logs... (Oracle does)

Regards,

Olivier