Minimally logged

• Yuri55

  SSCrazy Eights

  Points: 8449

  More actions

  October 20, 2005 at 3:31 pm

  #166416

  From BOL we know that some operations like writetext and updatetext are minimally logged in Bulk-Logged mode. I tested these two statements on my DB in 2 different modes: Full and Bulk-Logged. And found that transaction log file growth was the same regardless the mode (100,000 operations, updatetext- 6G, writetext-1,5G). There should be some explanation for this result.Thanks 

• Japie Botma

  SSCrazy

  Points: 2990

  More actions

  October 21, 2005 at 1:34 am

  #599024

  I am responding because I would also like to hear an answer (if any) on this one.  I do log backups every hour to keep them small.

  5ilverFox
  Consulting DBA / Developer
  South Africa