Afficher un message
Vieux 21/05/2008, 18h33   #1
Chris Wood
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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


  Réponse avec citation
 
Page generated in 0,04828 seconds with 9 queries