February 12, 2006 at 4:16 am
I had a couple of questions that I would appreciate if somebody answered. Firstly, does a t-log backup capture the entire log as it is, or does it capture it until the minLSN and leave apart the active portion of the log? In the latter scenario, there would be some overlap between consecutive log backups. Also, does a t-log backup capture the log as it was when the backup started or does it capture the image until the backup ends?
February 15, 2006 at 8:00 am
This was removed by the editor as SPAM
February 15, 2006 at 9:58 am
A log backup captures all transactions, including incomplete ones, in the tlog. When a log backup is restored, SQL Server rolls back all transactions that were incomplete at the time the log backup began. I guess that answers your second question also i.e. the log backup captures the state of the log at the beginning of the backup operation.
Greg
Greg
February 15, 2006 at 10:32 am
From BOL...
The transaction log is a serial record of all the transactions that have been performed against the database since the transaction log was last backed up.
When restoring a transaction log backup, It rolls forward all changes recorded in the transaction log. When SQL Server reaches the end of the transaction log, it has re-created the exact state of the database at the time the backup operation started. If the database is recovered, SQL Server then rolls back all transactions that were incomplete when the backup operation started.
-Krishnan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply