[dba-SQLServer] HELP - Log file growing rapidly

Why not change the recovery model of your database to 'SIMPLE', meaning
minimal log space is used?

I can't see that you'll need a point-in-time restore, so there's no point
use FULL or BULK-LOGGED recovery models...

-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Tuesday, 7 September 2004 3:14 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

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.