[dba-SQLServer] HELP - Log file growing rapidly

Hi John:

Can you not put a limit of the log file's growth, have an alert set to
notify you when the hard drive capacity has reached your set maximum then
delete the log file. See article:

http://www.winnetmag.com/Article/ArticleID/19761/19761.html

HTH
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W.
Colby
Sent: Monday, September 06, 2004 10:44 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] HELP - Log file growing rapidly


I am importing this data into the server.  The log file is growing rapidly.
It is currently at 23g, where the 4 data files are around 13g each.  Is this
natural or is it growing this rapidly because I am importing simultaneously
from the 4 different machines?

With 144g of free space on the drive that the log file is on, I am in no
danger of running out of room, certainly not before the current set of
imports finish.  However it appears that I do need to figure out how to
backup the log files so that I can re-use the room for the next set of
imports.

John W. Colby
www.ColbyConsulting.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com