November 9, 2012 at 6:59 am
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
November 9, 2012 at 8:31 am
Read this article, it should clear it up for you.
November 9, 2012 at 8:39 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply