How to disable Logging when loading the database?

[davidchardonnet]

Hello,

I have to fill a complete database from big files (about 1 000 000 lines each). For that, I use stored procedures on the database that create and fill the tables.
The filling of the database is done once. So it grows from zero to 2 or 3 gigabytes in a very short time.
And it happens I must fill it
The problem I have is that the log file becomes too large and i can't insert anymore when the log file is about 2 Gb.

I think that I don't need logging during this mass data insertion, but I need it in the everyday work. I also have to insert again data, on a regular basis, and disable logging on a particular day, always a big data volume.

Do I have to create the database whith special options, or are there administrative procedures I have to plan regularly?

Thank you

David

 

[JayKusch]

May want to look in Books OnLine (BOL) on Bulk Copying

Thanks

J. Kusch

 

[davidchardonnet]

I found the solution:

The Log file, I don't accept automatic growth when I create the database. And when inserting, the file remains the same size.