Reduce Transaction Log from SAP

[former_member309601]

Hi, I have Win2003 and SQL Server 2005, I want know which is the best choice for reduce the size of transaction log. Can I do it from SAP? ..... I have read and from SQL there is a command: DBCC SHRINKFILE , however I want know if there is some problem if I apply it from SQL Server.

Where do I define Transaction Log size?

Regards.

[Former Member]

The DBCC commands are issued at the SQL Query level.

If the DBA has the backups configured to run at the optimum interval, regular shrinkfile commands should not have to be run.

[former_member309601]

Hi, using SQL Server tools (Enterprise Manager) I can manipulate log file, backup database and shrink. I use this tool and I haven´t problems with SAP.

Regards.

[Former Member]

That is correct.

Enterprise Manager is a GUI that works at the SQL Query level.

[antonio_voce]

Hi ,

you must regurlary run the backup of log file.

Antonio Voce