Database Discussion - Limit LDF size in MS SQL Server

Print Page | Close Window

Limit LDF size in MS SQL Server

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19448
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Limit LDF size in MS SQL Server

Posted By: Bluefrog
Subject: Limit LDF size in MS SQL Server
Date Posted: 20 April 2006 at 7:52am

Does anyone know any best practices to limit the size of an LDF (transaction log) in MS SQL Server 2000?

I'd like to limit it to a couple GB or so. Under 1 is better though.

-------------
http://renegademinds.com/" rel="nofollow - Renegade Minds - Guitar Software http://renegademinds.com/Default.aspx?tabid=65" rel="nofollow - Slow Down Music

Replies:

Posted By: michael
Date Posted: 20 April 2006 at 2:33pm

ALTER DATABASE [Bluefrog] SET AUTO_SHRINK ON WITH NO_WAIT
GO
ALTER DATABASE [Bluefrog] MODIFY FILE ( NAME = N'Bluefrog_Log', MAXSIZE = 1024000000KB )
GO

Problem with that though is that you may get error messages saying the log is full. I would definately change the db model to simple with

ALTER DATABASE [Bluefrog] SET RECOVERY SIMPLE WITH NO_WAIT
GO

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker