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?
If you set this to true, then every minute or so, a checkpoint occurs. The transaction log is then truncated.
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.
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
Thanx alot. I know understand the truncate checkpoint concept.
Viewing 3 posts - 1 through 2 (of 2 total)