March 26, 2013 at 12:49 am
Hello SQL Masters,
Greetings!
I would just like to ask regarding Transaction log backup. While backing up the T-log, is there still incoming transaction to write on log?
Thank you and Best Regards,
March 26, 2013 at 12:57 am
Yes. There can be incoming transactions when a transaction log backup is in process.
The backup will include the transactions even if they are uncommitted with appropriate status information so that the restore process can rollback or roll forward the transactions.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 2, 2013 at 11:44 am
Hello,
Thanks for the response. 🙂 I understand now. 🙂
Thank you and Best Regards,
Dev1
April 2, 2013 at 12:44 pm
Yes, additional writes can occur to the log after you start a log backup.
But the log backup itself will contain only logs records up to the time the log backup started.
Stated another way: new log records written after the log backup starts are not written to the log backup that is running at the time.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply