Find Database backup history in SQL Server

Find Database backup history in SQL Server

question-markI had one article yesterday which finds out database restore history by querying some of the system table resides in MSDB database. After reading that article, I got question in my “Quick Learn” forum as well as in Twitter too that how can we find database backup history?

In fact, we needs to find database restore history only in rare case but it is mandatory for DBA to keep a track of the backup history. I have already written article which provides TSQL script which will cater the need of finding database backup history. Click here to see the script.

BTW, recently I have started one section in “Quick Learn” forum where you can come and ask me any SQL Server related question. Click here to ask me any SQL Server or .NET related question.

We have experts working in different Microsoft Technology and if you are facing any issues in .NET, SQL Server, Windows Azure or open source technology, do raise your question here from this URL.

BTW, the main idea to start “Quick Learn” is to provide the stage to learn/share short tips related to any technology so if you are having good tips to share, you are more than welcome at “Quick Learn”  and at the same time, if you want to learn some short tips, do drop by at “Quick Learn” .

I welcome you all to register there in “Quick Learn“. here is the link for registration.

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Quick Learn

Note: Microsoft Books online is a default reference of all articles .

Author: Riteshshah

Ritesh Shah is a database professional with having 16+ years of experience in various domain of IT field. He is a author of many technical articles on Microsoft Technology and authored a book of SQL Server 2012 Performance Tuning cookbook. He loves work with different Microsoft Products.

3 thoughts on “Find Database backup history in SQL Server”

  1. Magnificent site. Lots of helpful info here. I am sending it to several friends ans additionally sharing in delicious. And of course, thank you for your sweat!

Comments are closed.