SQL SERVER 2008 Log Truncation

[former_member184628]

Hi All,

I am trying to reduce the log file size of Sql Server 2008.

After complete DB and log backup, I am executing statement

USE SID

DBCC SHRINKFILE(SIDLOG1, 10)

The below msg is displayed.

Cannot shrink log file 2 (SIDLOG1) because the logical log file located at the end of the file is in use.

(1 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I tried this sql query:

select name, log_reuse_wait_desc

from sys.databases

master NOTHING

tempdb NOTHING

model NOTHING

msdb NOTHING

SID LOG_BACKUP

Please let me know on how to proceed.

I am referring to couple of SAP notes also: 625546, 1651592, 1409312 and 363018.

Also I dont want to change the recovery model to simple

Regards,

Sharib Tasneem

[Former Member]

Hello Sharib,

Refer to below forum which address the same issue.

Thanks,

Arjun