Post reply

Bulk Insert

  • July 21, 2006 at 8:36 am

    #114808

    Is a bulk insert statement written to the transaction log?  If I do a bulk insert of 15,000 rows is it logged as 15,000 inserts or 1 insert?  Basically I want to not make the translog grow.

    thanks!

  • July 21, 2006 at 12:47 pm

    #650826

    You can put the database in 'bulk-logged' mode and they won't grow as big.

    You can change it back when finished.

     

  • July 23, 2006 at 10:37 pm

    #650978

    It will be only one insert in log file .

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply