Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Roshan Joe Joseph,
There are at times when different teams have control over a particular server but you have the responsibility of restoring the database in case of disater. This is a tricky situation. If you dont have a policy regarding backups? You should have a record of recent backups in the server for each databases. If you have knowledge on say when was latest full/differential/log backup taken on a particualr database, you will not be totally lost in time of a catastrophe. If you are new to the environement, this script will give you an idea of what backup plan goes on each database. Especially if you administer multiple servers, it will help you document your backup locations.
How to use the script
The procedure uses msdb to get the relevent backups you need to look at.
The Procedure can be executed in 3 ways.
Hope this script will be useful for you.
Differential Backup of Database failing due to ntbackup and SQL Server VSS Writer Service Running
Differential backup in 2005
Restore multiple Differential backups
Differential Backup Size
Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.