• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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