Thanks for the nice article I will bookmark it for my favourite.
One question about the below statement,
Because of this behaviour, when a database is in full recovery model and the database is damaged in such a way that the transaction log is intact and undamaged, a tail-log backup can be taken which holds the last transactions that occurred in that database. Hence, assuming the database's transaction log is intact, it is possible to restore without data loss in case of a disaster.
How do we know if it is the data file or transaction log file is damaged?
How can we check if a transaction log is intact or not?
Thanks