Shrink Log file in simple mode not working

Question

To shrink the log file of a database, I changed the mode to simple and executed the shrinkfile command but the file does not get shrinked. Why is it so even in simple recovery mode?

Answer 1

Hi @Surendra Adhikari ,

Could be this helpful for you?

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/be296e6a-8343-4473-bae8-3791091368c0/sql-server-2012-db-log-file-doesnt-shrink-simple-recovery-model?forum=sqldatabaseengine

Answer 2

What does

select name, log_reuse_wait_desc  
from sys.databases  

return for the database in mind? Is there logshipping, replication or etc. setup for the database?

Answer 3

Executing checkpoint before shrinkfile helped.
Thank you all for replies.

Answer 4

Hi @Surendra Adhikari ,
If you wanna shrink file in the simple mode, you need to truncate the log. To execute checkpoint is a way and you can also do the full backup, which will have the same effect. :)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 5

Use Checkpoint before running the shrink command. Thanks