deleting old logs

[nelson_chamba2]

Hi folks,

I´m running solution manager 7.1 on Windows 2008R2 with MS SQL 2008 R2. My database partition is full and my system is not starting anymore, how do i delete some old logs to free my space?

My SLMLOG1.ldf file has 279 GB.

Any idea please

Regards,

Nelson Chamba\

[Sriram2009 · Accepted solution]

Hi Nelson

In your MS Sql DB log size? you can perform the truncate transaction log

Refer the Microsoft link - Back Up a Transaction Log (SQL Server)

Regards

Sriram

[nelson_chamba2 · Accepted solution]

Hi Sriram,

sorry but can you go deep, i´m not a DBA, but i have full access to my MS SQL Server. The problem is that i don´t have space on my harddisk and this SLMLOG1 grew so i´m in trouble now.

Regards,

NC\

[Sriram2009 · Accepted solution]

Hi Nelson

You already said that MS Sql log size 250 GB  you have to do the truncate log backup. Normally how you are taking the daily database level backup? is this any tool used?

BR

SS

[nelson_chamba2 · Accepted solution]

Hi Sriram,

I use the sap and ms sql tool to a external drive via db13.

regards,

nc\

[Sriram2009 · Accepted solution]

Hi NC

Could you refer the SAP Note for DB full

  625546 - Size of transaction log file is too big

BR

SS

[nelson_chamba2 · Accepted solution]

Hi SS,

Let me run first the full external backup and them get back to this just for precautions.

Can you help me understand this line from the note please:

<size> = the size the logfile should be shrunk to, e.g. 10 -> 10 MB.

My now is 250GB so?

Regards,

NC

[Sriram2009 · Accepted solution]

Hi NC

Normal Windows OS & SAP Usr folder how you are taking backup? same way you can perform the MS Sql DB transaction log backup to either disk or tape drive.

for this you can refer the Microsoft link - Back Up a Transaction Log (SQL Server)

BR

SS

[Sriram2009 · Accepted solution]

Hi NC

1. I thing same amount of transaction log file should shrink.

2. Normally everyday one the database backup get it completed you have to start the MS Sql truncate log backup. then you may not get in to this issue.

BR

SS

[Ambarish · Accepted solution]

Hi Nelson,

To free up space - You can backup transaction log file and truncate it. ( Or simply shrink database from enterprise manager). However for shrinking the datbase size your database recovery type should be "simple". You can check recovery type of your database in "options".

Thanks,

Ambarish

[Former Member]

Hi Nelson

You can use SLG2 to delete expired/old logs

Please see

Regards

Dharmendra