Answer
A backup taken before restoring a damaged DB to prevent data loss. Captures last active log records.
Quick Answer
A tail-log backup captures the end of the transaction log after a failure but before restore begins. Without it, you lose all transactions between the last log backup and the crash. It's the last piece of the restore chain. Required when recovering a Full-model database to the point of failure.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ