Sunday, March 11, 2012

Check database integrity and backup question

In my backup schedule, I check to "Check database integrity" at 4:00 am and
schedule the backup at 4:30 pm. What happen if the database integrity is not
finish by the time the backup schedule starts ? Thanks.The backup will go ahead as normal. Backups in SQL Server are online, and
are not blocked by other processes whether that is an integrity check or a
normal update.
--
Jacco Schalkwijk
SQL Server MVP
"fniles" <fniles@.pfmail.com> wrote in message
news:uvjunGnJFHA.3420@.tk2msftngp13.phx.gbl...
> In my backup schedule, I check to "Check database integrity" at 4:00 am
> and schedule the backup at 4:30 pm. What happen if the database integrity
> is not finish by the time the backup schedule starts ? Thanks.
>

No comments:

Post a Comment