How to shrink a database's log file - especially when most of the log is of no value after about 1 year?
-
Saturday, May 05, 2012 12:36 AM
As per the title, I have multiple gigabytes in my log file(s) for each of the 3 databases in my application.
Is there a straightforward method to reducing (deleting the logs more that 1 year old for example?
Rich Balluff
RLB Associates
All Replies
-
Saturday, May 05, 2012 12:58 AMModerator
Check below links
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2530305f-71a8-4a10-b388-15049c2fefe2
http://msdn.microsoft.com/en-us/library/aa258287(v=SQL.80).aspx
Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.- Proposed As Answer by BalmukundMicrosoft Employee, Moderator Saturday, May 05, 2012 3:22 AM
- Marked As Answer by amber zhangModerator Friday, May 11, 2012 8:50 AM
-
Saturday, May 05, 2012 3:22 AMModerator
Also refer
http://support.microsoft.com/kb/317375 (A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server)
In short, taking log backup and shrink should help.Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter- Proposed As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Saturday, May 05, 2012 3:30 AM
- Marked As Answer by amber zhangModerator Friday, May 11, 2012 8:50 AM
-
Saturday, May 05, 2012 3:31 PM
As per the title, I have multiple gigabytes in my log file(s) for each of the 3 databases in my application.
Is there a straightforward method to reducing (deleting the logs more that 1 year old for example?
Rich Balluff
RLB Associates
it is more a philosophical question but how do you know that you've logs more than 1 year old ?
if transaction log backups are done regularly than there should be no old transaction in the log files.
depending on the size of the databases or the number of transaction against the database multiple gigabytes for a transaction log file is nothing special.
@Rich
could you please explain with more details what your problem is?
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
-
Saturday, May 05, 2012 6:27 PM
- Proposed As Answer by Markwillium Tuesday, May 08, 2012 4:35 AM
- Marked As Answer by amber zhangModerator Friday, May 11, 2012 8:50 AM
-
Tuesday, May 08, 2012 4:37 AMShrinking the Transaction Log files in SQL Server
Read my blog (Blog)
Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you
.png)
