Post reply

Transaction log

  • July 6, 2004 at 11:29 am

    #102097

    How do I turn of the transaction log on SQL 2000 DB that needs to cleared on a regular basis?

  • July 6, 2004 at 11:42 am

    #513502

    You can't really "turn off" the transaction log.  Its an integral part of SQL Server.  You have two options for clearing the log on a regular basis.

    1.  You can do frequent transaction log backups.  In my shop, we do them every 15 minutes in most cases.

    2.  You can set the database to Simple Recovery Model.  This will cause SQL Server to clear completed transactions from the log regularly.  One note of caution: you lose point in time recoverability by doing this.  It is NOT recommended for a production transactional database.

    Steve

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

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