Solved

How do I control or limit log file growing in SQL Server 2000 ?

Posted on 2007-11-28
2
622 Views
Last Modified: 2008-02-01
My Log files occupied 20 GB. I could not shrink that file. so I detached the database and attached again.
It was just few days back.  size of the log file become just 570 kb.  Now it reaches 5,000,000 kb again.
How can I limit the growing?
0
Comment
Question by:peterdevadoss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
bsharath earned 50 total points
ID: 20364982
you can restrict it graphically using SSMS or Enterprise Manager.
Right-click on the database name and select Properties.

Note, however, if you limit the size and it fills up, ALL modification
activity will instantly cease on that database.

You MUST backup the tlog in some form or another to flush committed
transactions from the log (or put the database in simple recovery mode).


http://www.mcse.ms/message2593655.html
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20365106
Scripting is always better:
(of course change names and sizes to your own needs)

Hope this helps ...

USE [master]
GO
ALTER DATABASE [Yveau] 
MODIFY FILE ( NAME = N'Yveau_log', MAXSIZE = 102400KB )
GO
 
--

Open in new window

0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.

738 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