Solved

How do I control ldf file growth in SQL Server 2000

Posted on 2011-02-22
6
268 Views
Last Modified: 2012-05-11
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
Comment
Question by:woodwyn
  • 3
  • 2
6 Comments
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 34954575

Change the recovery mode to Simple and schedule regular backup of the log
This should keep it at a reasonable size
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34957359
>>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
 

Author Comment

by:woodwyn
ID: 34962941
Any recommendations on if either solution is easier to implement and/or more reliable as a solution to our problem?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 34963068

Either way should be fine
0
 

Author Comment

by:woodwyn
ID: 34963093
How does one set recovery mode to simple?
0
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 500 total points
ID: 34963119

run this command

ALTER DATABASE [database name]
SET RECOVERY [SIMPLE]
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL 2012 AOG and SQL2014 AOG 76 61
MSSQL join different row from other table 14 66
SQL Query Task 11 43
T-SQL and CLR parameter strings 9 28
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question