Thursday, March 29, 2012

DB Backup & Checkpoint

Hello,
My question is when you backup a db is a checkpoint issued at that time?
Are 'dirty' pages flushed to disk right before the actual backup begins?
Thank you.
Yes, checkpoint is automatically done before a backup.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"MedDBA" <MedDBA@.discussions.microsoft.com> wrote in message
news:CF8E6A4E-2F3C-4577-B210-8CB4D2B0B655@.microsoft.com...
> Hello,
> My question is when you backup a db is a checkpoint issued at that time?
> Are 'dirty' pages flushed to disk right before the actual backup begins?
>
> Thank you.
>

No comments:

Post a Comment