September 8, 2005 at 3:36 pm
I am using bulk insert (a textfile) into a table SQL-Server 2000.
This works excelent but even for small files the transactionlog is
growing out of control. The size of database is about 1 Gbyte and
the log 8 Gbyte.
Using DTS instead doesn't seem to create the same size of the log.
I have a long experience using DTS and VB importing big files but
I need a faster method and bulk insert is then recommended.
Any hint?
Gosta Munktell
September 8, 2005 at 3:58 pm
You must be using a full recovery model. under full recovery model all the chnages will be log. Based on you database requirement consider changing recovery model and also consider a small batch size
Amit Lohia
September 8, 2005 at 4:15 pm
Yes I did (by misstake)
The default recovery is full and switching to simple is good in
this case. Now I could shrink the database and will use simple.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply