Post reply

update table without trans log entries?

  • 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

  • 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
    Connect with me on LinkedIn

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

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