Home Forums SQL Server 2005 Backups Difference between Transaction Log & Database Log File RE: Difference between Transaction Log & Database Log File

  • July 15, 2008 at 12:43 pm

    #843344

    1. A log file is the physical location that holds the transaction log data.

    2. A full backup will backup enough of the transaction log to allow recovery of the database to the time the backup was taken.

    Greg