log size increasing in test system

[Former Member]

Hi Gurus

In my Test system log size is increasing daily it is showing around 203,700 MB instead of 2,700MB how can i reduced the size and the last good backup was 1 week before ie 23rd March 2008.

what procedures to be followed so the in DB02 i can see the logsize again back to normal,

I am using SQL database for SAP

regards

Piroz

Edited by: Piroz Eslam on Apr 4, 2008 2:32 AM

[Former Member · Accepted solution]

Hi,

check Note 363018 - File management for SQL Server

part E. Increasing and decreasing log files

read it carefully

regards,

kaushal

[Former Member · Accepted solution]

Hi

Thanks for your information, Solve the problem

Thread closed

regards

Piroz

[Former Member · Accepted solution]

Hello Piroz,

Could you please let me know what exactly the steps you took to reduce the log file size?

I am aware that I need to run daily, weekly, monthly reports to delte old logs. But this has not helped me till much extent.

Please help me in this.

Regards,

SAT