How can we help you today?

How can we help you today?

Does log backup set checkpoints?

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!

coleman November 02, 2005 09:41

0

Comments

2 comments

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

petey November 02, 2005 10:34

0
The answer is definitely yes.

joshmurrah November 03, 2005 13:48

0

Add comment

Please sign in to leave a comment.