Solved

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

Posted on 2007-11-28
2
608 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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

16 Experts available now in Live!

Get 1:1 Help Now