Post reply

truncate log on checkpoint

  • October 22, 2001 at 12:14 am

    #104518

    Hi all,

    I understand that only if we backup the database, the log space is freed. This is regardless whether the truncate log on checkpoint option is true or false.

    My doubt is, i found somewhere that this option (truncate log..) should not be set to true. If set to true, then, all the transaction log backups are a waste.

    How is this?

    Regards

    Parasu Raman


    Regards
    Parasu Raman

  • October 22, 2001 at 10:42 am

    #419174

    If you set this to true, then every minute or so, a checkpoint occurs. The transaction log is then truncated.

    Example:

    0800 DB full backup

    0805 write transaction 1

    0806 Check point, log cleared (marked as cleared)

    0807 transaction 2

    0808 db transaction log backup.

    At this point, the log backup is not usable because it will not contain transaciton 1.

    Steve Jones

    steve@dkranch.net

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • October 22, 2001 at 10:58 pm

    #419193

    Hi,

    Thanx alot. I know understand the truncate checkpoint concept.

    Cheers

    Regards

    Parasu Raman


    Regards
    Parasu Raman

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

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