Click here to Skip to main content
11,490,266 members (51,838 online)
Click here to Skip to main content

Tagged as

How to Shrink SQL Server database log files?

, 5 Jan 2011 CPOL 20.3K 13
Rate this:
Please Sign up or sign in to vote.
How to Shrink SQL Server database log files?
Database Logs should be truncated whenever you perform a full backup of the database. You can also manually truncate them as follows.

Code

DECLARE @strDatabaseName nvarchar(255)
SET @strDatabaseName = 'YourDatabaseName' 
BACKUP LOG @strDatabaseName WITH TRUNCATE_ONLY 
DBCC SHRINKDATABASE (@strDatabaseName, 0)--Parameters are Database Name & Target %
It was tested in SQL Server 2005 & it's working. It was also tested in SQL 2008 & it's working too.

For Your Information

Why won't my transaction log shrink?[^]

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

thatraja
Web Developer
India India
Programmer | Dude | ||||||

About him & his blog? check out here. Currently he's updating the site, he'll return soon there with more things*.

In Codeproject, he posted a blogpost & more than couple of Tip/Tricks, hope he'll write more soon.

Favorite techs are MVC, WCF, Mobile, HTML5, CSS3, jQuery, etc.,

His hobbies are watching movies, CP, being alone, etc., But now he's working on something*.

* - SCAMP???
Follow on   Twitter   Google+   LinkedIn

Comments and Discussions

 
GeneralReason for my vote of 1 Not a good advice Pin
msmits10-Jan-11 3:08
membermsmits10-Jan-11 3:08 
GeneralReason for my vote of 4 Good Tip....... Pin
Vivek Johari6-Jan-11 17:30
memberVivek Johari6-Jan-11 17:30 
General@HLogic: Hi it's just a Tip/Trick so I just entered script o... Pin
thatraja4-Jan-11 15:52
mvpthatraja4-Jan-11 15:52 
@HLogic: Hi it's just a Tip/Trick so I just entered script only, otherwise(I mean it was article or blog) I would be explained other things well. Thank you.
GeneralReason for my vote of 1 Log files do not need to be truncate... Pin
HLogic4-Jan-11 15:20
memberHLogic4-Jan-11 15:20 
GeneralReason for my vote of 5 ok log Pin
ronal74-Jan-11 10:55
memberronal74-Jan-11 10:55 
GeneralReason for my vote of 5 its good tip Pin
Pranay Rana3-Jan-11 0:32
memberPranay Rana3-Jan-11 0:32 
GeneralYou shouldn't shrink whenever you do a full backup... Pin
msmits10-Jan-11 3:06
membermsmits10-Jan-11 3:06 
GeneralRe: You shouldn't shrink whenever you do a full backup... Pin
thatraja10-Jan-11 5:20
mvpthatraja10-Jan-11 5:20 
GeneralWelcome Pin
thatraja1-Feb-10 22:44
memberthatraja1-Feb-10 22:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.150520.1 | Last Updated 5 Jan 2011
Article Copyright 2010 by thatraja
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid