[dba-SQLServer] Truncate a log file from code

jwcolby jwcolby at colbyconsulting.com
Fri Nov 30 23:04:05 CST 2007


I am doing an entire directory of files, using SQLBulkCopy to import the
text files into a temp table, and from there into a permanent table.  The
log file is about the same size as the data file.  Is it possible to
truncate the log file after every file import in order to minimize the disk
impact?  If so can you point me to example code?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 




More information about the dba-SQLServer mailing list