[dba-SQLServer] HELP - Log file growing rapidly

John W. Colby jwcolby at colbyconsulting.com
Mon Sep 6 12:44:15 CDT 2004


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 





More information about the dba-SQLServer mailing list