Solved

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

Posted on 2007-11-28
2
611 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
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Testing connection to sql 7 58
configure service broker on all databases 2 78
Restrict result set 1 35
Can Unique column have more than one Null? 8 48
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.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now