In the middle of a crisis, where you fear the database is lost, and you need to get it back up and running as quickly as possible, it’s easy to jump right into the Recovery Phase and start restoring the backups that you’ve been carefully creating. But there is an intermediate step that you should investigate before you start, and it can possibly restore the database to the exact point at which it failed,regardless of when the last Transaction Log Backup was made. The process is called restoring a Tail Log Backup. 

So the Tail Log of the transaction contains everything that occurred after the last Transaction Log, or the Full Backup has occurred. Depending on the type of failure the database experienced, it’s possible that the Transaction Log still contains salvageable information that can be beneficial in a Database Restore scenario.It’s always worth remembering to try and preservethis information, even after a disaster has already struck.

Sources:

https://www.linkedin.com/learning/designing-database-solutions-for-sql-server-2016/restore-tail-log-backups

Last modified: March 18, 2019

Author

Comments

Write a Reply or Comment