Log file is not Shrinking on SQL Server

Question

I wanted to shrink the log file as much as possible by the command:

DBCC SHRINKFILE ('LogFile', 10)

and get this error:

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

I tested these solutions, but my problem isn't solved yet

How can I solve this problem?

SOLVED

I executed this query

SELECT name, database_id, log_reuse_wait, log_reuse_wait_desc FROM sys.databases

Result:
log_reuse_wait_desc: CHECKPOINT

and after execute CHECKPOINT and DBCCSHRINKFILE my problem solved.

What does this show? SELECT name, database_id, log_reuse_wait, log_reuse_wait_desc FROM sys.databases — manderson, Feb 21 '17 at 18:10
Looks like there was some success here. https://www.sqlservercentral.com/Forums/Topic122690-24-1.aspx — manderson, Feb 21 '17 at 18:16
I executed CHECKPOINT & DBCC SHRINKFILE, and my problem solved. — M. Rezaeyan, Feb 21 '17 at 18:17

score 0 · Accepted Answer · answered Feb 22 '17 at 05:53

0

I executed this query

SELECT name, database_id, log_reuse_wait, log_reuse_wait_desc FROM sys.databases

Result: log_reuse_wait_desc: CHECKPOINT

and after execute CHECKPOINT and DBCCSHRINKFILE my problem solved.

answered Feb 22 '17 at 05:53

M. Rezaeyan

1 Answers1