Hi,

I have a table of 300 million rows that needs to be bcp
out into a flat file. Will this create a huge tran-log in
the database? If so, I need to know in advance to
allocate more t-log space.

and If so, will the tran-log be written simultaneously as
the bcp out running or will happen late (being delayed)
due to the huge transaction has to be logged?

thanks a ton!!

JJ

There is going to be some sort of log, more or less depending on your
recovery model (check book online for bulk_logged). Since this is a read
process, I don't expect to see much logging here. However, it would take a
while to generate that big flat file.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net


"JJ Wang" <anonymous (AT) discussions (DOT) microsoft.com> wrote