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

  • 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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy