asked
How can I reduce the size of a log file?
I have a 108GB log file that I'm trying to reduce in size. i have backed it up along with the database and also tried shrinking it with no luck. Any help would be greatly apprecaited.
This site runs on votes. Please mark all helpful answers by clicking on the thumbs up. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
Pretty simple, but just shrinking the log won't fix your issue. You probably have the database in full recovery model and are making database backups but not backing up your log. To get the file under control you should switch to simple recovery, then back to full to truncate the log then you can shrink the file. To keep this from happening you should either schedule regular log backups if you need them for a point in time recovery. If you don't need a point in time restore then just switch to simple and leave it there and then shrink the file. You can read about it on my [blog](
http://timradney.com/2011/08/31/shrinking-transaction-logs/)
Is this database being used for replication or mirroring? If so, then check that the mirror / replication systems are all up & running properly. Also, have a look at the output of [link text][1]`DBCC OPENTRAN`, as it's possible you have some other long-running transaction preventing log reuse. [1]:
http://technet.microsoft.com/en-us/library/ms182792.aspx
17 People are following this question.
