update table without trans log entries?

• mhweiss

  SSCarpal Tunnel

  Points: 4284

  More actions

  July 9, 2002 at 5:12 pm

  #78980

  I would like to be able to update the data in a table without the transactions being logged in the trans log...is there a way to do this? This is in a data warehouse and the raw data can always be imported again so there is no need to keep a record of the transactions and doing so balloons the trans log substantially sometimes causing disk space errors...

  Thank you,

  Michael

  Michael Weiss

  
  Michael Weiss

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 9, 2002 at 9:58 pm

  #432309

  Everything gets logged, but you can set the recovery mode to simple (SQL2K) or truncate on checkpoint in SQL 7. You still have to have a log big enough for a single transaction to execute though.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter