Return
-
Title
Display last backup dates for different SQL Server backup types -
Description
For SQL Server databases, what does the Last Backup date in agent's Database drilldown page represent, and is there a way to see the last backup dates for other backup types?
-
Cause
The Last Backup field in the Database drilldown retrieves the most recent date from the SQL Server instance for the last backup date among any type of backup (i.e.Full, Differential, Log). -
Resolution
Beginning in the 5.6.7 SQL Server database cartridges, three additional columns have been added to identify last backup dates for specific types of SQL Server backups
- Last Backup Full Time
- Last Backup Differential Time
- Last Backup Log Time
These new columns are not displayed by default and can be enabled by editing the "Show Column" button on the database dashboard and enabling the checkboxes for each of these three columns then clicking the "Apply" button.