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.
>

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.
>

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.
>sql

DATENAME - can you not get it to say the actual day name?

SELECT DATENAME(day, getdate()) AS 'Day Name'

comes back as 15 but i want it to come back with thursday

Cheers,
Craig

use dw

SELECT DATENAME(dw, getdate()) AS 'Day Name'

this stuff is clearly documented in BOL with in the section on datename

|||

what makes it worse is that i was sitting looking at datename page in BOL

jsut one of those days where you cant see the wood for the trees!!

soz,
Craig

|||at least you looked before you posted :)