Sql shrink log file 2008

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline. Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future. There are many issues included here, but I would list two major issues: 1 From the setting database to simple recovery, shrinking the file and once again setting in full recovery, you are in fact losing your valuable log data and will be not able to restore point in time. Core 2 Duo. Leave new baskarlak. Wyatt Wong. What should I do? Luiz Mercante. Need your help at the earliest as I am in a very critical situation.

There is no database name in line 4. Regards; Raj. Hi,This is very useful for me. Thanx for such a useful blog. I had shranked sql database log files but there was no space recovered from server? Can you help on this…. Jorge T. Facebook Twitter Reddit LinkedIn. Royce Wilkerson. Main Areas of Contribution:.

Track Progress. Earn Credits. Robert for Microsoft Oct 12, at am. The reason you don't want to shrink the log file repeatedly is: 1. Collectives on Stack Overflow. Learn more. SQL - shrink database log file Ask Question.

Asked 11 years, 11 months ago. Active 4 years, 7 months ago. Viewed 4k times. I am trying to shrink my database log file. Am I missing something? Aaronaught k 24 24 gold badges silver badges bronze badges. As a general rule, shrinking your files is a bad idea. Sorry, but I'm very new to this.

Why is it a bad idea? It's a poor practice because it negates the purpose of the transaction log in the first place. That's why SQL Server removed this ability. Why would you set to simple? You will lose any transaction information.

Then you can shrinkfile with no issue. How to shrink the transaction log.