SQL Server – Get Database Backup History for Crash Recovery

Spread the love

It is not easy to find out right backups for restore activity when people are watching you during database crash situation. So I have created below TSQL script that would give backup history for single or multiple database(s) to perform latest database restore, or Point-In-Time recovery.

Below is the sample output:-

Friends! Please feel free to correct me by comments. If you liked the article, do Like, Share & Comment. Happy Coding 🙂

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.