Home Forums SQL Server 2005 Backups Log backups while Full/Differential backups are running RE: Log backups while Full/Differential backups are running

  • April 23, 2013 at 9:50 am

    #1609147

    Lynn Pettis (4/23/2013)

    pdanes (4/23/2013)

    GilaMonster (4/23/2013)

    pdanes (4/23/2013)

    So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get incorporated?

    No, not at all. A backup (full or differential) is consistent as of the time that the backup completes.

    What did I say that implied your conclusion?

    Actually Gail said the last full backup that COMPLETED prior to the START of the log backup(s).

    So she did, and I don't think I implied otherwise in my subsequent questions. Naturally, a backup that hasn't completed is of no use to anyone. I don't understand your point.