Effect of Backup Log with Truncate_only on the automatic Checkpointing of a DB
Hi,
We are running SQL2005 SP2 build 3175, soon to be 3239, and have some
conversion jobs that use Backup Log with Truncate_Only. The analyst says
that the checkpoint task blocks the conversion job. Personally I can't wait
for SQL2008 to stop the Truncate_only option, but that's beside the point.
I believe that the checkpoint has trouble because of the Truncate_Only which
is run after a number of transactions have been applied to the database. Is
this a true argument?
Thanks
Chris
|