Post reply

Difference between Transaction Log & Database Log File

  • July 15, 2008 at 11:42 am

    #195285

    Hi,

    1-Whats the difference between Transaction Log & Database Log File?

    2-When we take back of a database, does it also includes the Database Log File in the backup?

    Thanks,

    Usman

  • 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

  • July 15, 2008 at 12:48 pm

    #843350

    So how will the data BETWEEN a full backup and a transactional backup will be restored, assuming that checkpoints occurs AFTER the full backup and data was flushed and REMOVED from the transactional log into the database(this data will not be available in the backup or transaction log).

  • July 15, 2008 at 12:51 pm

    #843353

    Transaction log entries are only purged on checkpoint if you are running in simple recovery mode. If you are in simple recovery mode, you cannot run log backups at all.

    In full recovery mode transaction log entries are only removed from the log after a log backup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 15, 2008 at 12:54 pm

    #843357

    Gila u r just too gud.......

    Greg thanks alot that helpfull too.........

    Thanks,

    Usman

  • April 17, 2009 at 9:16 am

    #979740

    hi this is vijayanand and im from bangalore,

    logfile: It hold the eventual information or history information of a data.

    Tlog: It holds no data ,it holds only the structure ,

    This is very important and most of the people miss their view in simple thinks

    Thank you

    sanna:-)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply