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

  • GilaMonster (4/23/2013)


    pdanes (4/23/2013)


    What state are such backups in when they are taken?

    The same state they would be in if they were taken without a full/diff running

    What does a transaction log backup give you when it's taken during a full ordifferential backup?

    A log backup file containing all the log records since the last log backup, same as it would if it were running at any other time

    Where do you start and what do you use if you need to restore such a database?

    A full backup that completed before that log backup started and an unbroken chain of log backups from the full backup up to the point you need to restore to.

    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?