• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

How do I control ldf file growth in SQL Server 2000

I have a customer with a SQL Server 2000 database that doesn't get much maintenence.  Every once in awhile the ldf file grows to big for the disk space and locks up the server.  Is there a way to automatically shrink the ldf file or minimize the file growth?  This is a daily backup database populated with DTS every night for easy access to yesterday's data if ever necessary.  It is not a production db.  
0
woodwyn
Asked:
woodwyn
  • 3
  • 2
1 Solution
 
Ephraim WangoyaCommented:

Change the recovery mode to Simple and schedule regular backup of the log
This should keep it at a reasonable size
0
 
Anthony PerkinsCommented:
>>Change the recovery mode to Simple and schedule regular backup of the log<<
I suspect you mean:
Change the recovery mode to Simple or schedule regular backup of the log

You cannot do both.
0
 
woodwynAuthor Commented:
Any recommendations on if either solution is easier to implement and/or more reliable as a solution to our problem?
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Ephraim WangoyaCommented:

Either way should be fine
0
 
woodwynAuthor Commented:
How does one set recovery mode to simple?
0
 
Ephraim WangoyaCommented:

run this command

ALTER DATABASE [database name]
SET RECOVERY [SIMPLE]
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now