Transaction log backup

• Megistal

  SSCrazy Eights

  Points: 8787

  More actions

  November 9, 2012 at 6:59 am

  #284610

  Full database backups represent the database at the time the backup finished

  http://technet.microsoft.com/en-us/library/ms186289%28v=sql.105%29.aspx

  I can't find the same piece of information about the transaction log. From my understanding it would be at the start of it (The log backup would represent the database at the time the log started (using the first LSN)). Every committed transactions will be backup, ongoing transactions would be undo if we were to restore that log backup.

  I wish to find if the log backup has the same mechanism as a full backup (data + the transaction log portion while the backup was running) or not.

  Ty

• winston Smith

  SSCoach

  Points: 19484

  More actions

  November 9, 2012 at 8:31 am

  #1557643

  Read this article, it should clear it up for you.

  http://msdn.microsoft.com/en-us/library/ms191429.aspx

• Megistal

  SSCrazy Eights

  Points: 8787

  More actions

  November 9, 2012 at 8:39 am

  #1557647

  Meanwhile, I've found my answer:

  Restoring a log backup rolls forward the changes that were recorded in the transaction log to re-create the exact state of the database at the time the log backup operation started

  http://msdn.microsoft.com/en-us/library/ms190440%28v=sql.105%29.aspx