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

Quick Learn

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

3 thoughts on “Find Database backup history in SQL Server

  1. Synthia

    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!

  2. Pingback: Mirror backup to take full backup at multiple location in SQL Server

  3. Pingback: Split SQL Server Full backup in multiple files for faster backup

Comments are closed.