Does log backup set checkpoints?

coleman · November 2, 2005 9:41AM

I'm now moving my log backups over to SQL Backup, and I can't seem to determine if it sets checkpoints upon backup or not. Our database gets a lot of activity so it's important for us to keep the log files truncated regularly.
Thanks!

petey · November 2, 2005 10:34AM

A SQL Backup transaction log backup works very much like a native trx log backup. Use DBCC SQLPERF (LOGSPACE) to verify this.

joshmurrah · November 3, 2005 1:48PM

The answer is definitely yes.

Does log backup set checkpoints?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk