Here is the quick script I use find last backup time for all the databases in my server instance.
SELECT sdb.Name AS DatabaseName, COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),'-') AS LastBackUpTime FROM sys.sysdatabases sdb LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name GROUP BY sdb.Name
The query above will return following result where we can see the database last database backup date and time.
Do you use any other script for the same purpose, please share here, it will be interesting for all of us know.
Here are few other blog posts which are related to this subject.
- What is a Backup Timeline for Restore Process? – Interview Question of the Week #092
- What is Copy Only Backup in SQL Server? – Interview Question of the Week #128
- SQL SERVER – 5 Don’ts When Database Corruption is Detected
- How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
- SQL SERVER – Finding Last Backup Time for All Databases – Last Full, Differential and Log Backup – Optimized
- SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
If you ever find your TEmpDB to be full and if you want to move TempDB, you will find this blog post very helpful. Make sure that TempDB is set to autogrow and do not set a maximum size for TempDB.
Reference: Pinal Dave (https://blog.sqlauthority.com)