Find Database backup history in SQL Server
I 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.
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” .
Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles .