How do I disable transaction logging in SQL7.0

  • I there any way that I can switch off transaction logging on SQL 7.0? We have a test environment and keep running out of disk space because of the growth of the transaction log file while trying to run massive deletes, etc.

  • You cannot turn it off. You can set the recovery mode to simple (truncate on checkpoint in SQL7). It will still log everything but completed transactions are not saved. You still have to have enough room for your normal operations, big enough to handle your largest transaction.

    If it just deletes that are causing a problem, try using truncate table instead of delete. Much faster and a lot few log entries.

    Andy

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

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

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