Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Suppose a long transaction is running, which also means as usual it is writing entries into the log.
Suppose tlog backup runs at this point, then how does sql server handle this scenario?
Does the log backup contain the ongoing transaction entries?
Does the log get truncated post backup? Assuming the transaction is still running.
I don't have the precise internals, but basically, when any backup starts it has to allow for the fact of data in motion. So a marker is held that shows which transactions are open at the start of the backup process. Anything that is still open at the end of the backup is marked that way in the backup itself. During the restore process, at the recovery step, incomplete transactions are dealt with to ensure data integrity.
