Page History

...

• Identify any non-backed up databases.
• Determine databases not backed up within the last x days.
• Determine which databases are in simple or full recovery mode.
• View the last backup time stamp for each database.
• Drill into the complete backup history for a specific database.
• View backup history across multiple SQL Server instances or a server group.
• Save the backup history.

...

Check this box for the Backup Status tool to include only those databases that include a full database backup.

Exclude Offline Databases

Check this box for the Backup Status tool to exclude all offline databases from the backup status check.

Include all nodes

Check this box for the Backup Status tool to include all nodes in the backup status check.

Use the Backup Status tool

...

1. Open the IDERA SQL Admin Toolset Launchpad, and then click Backup Status.
2. Specify whether you want to back up a SQL Server instance or a server group.
3. Search for and then select the SQL Server instance or server group whose backup status you want to check. To specify multiple SQL Servers, separate each instance name with a semicolon.
4. Optional. Check the options you want to use in this status check.
5. Click Get Backup Status. The Backup Status tool checks the backup status of the appropriate instance or group.
6. If you want to view the backup history for a specific database , select the database from the status list, and then click Show Backup History for Database.
7. If the tool returns unexpected results , check the groom settings on the SQL Server instance. For example, if the backup operation status is recently groomed, the tool may return a partial history, such as a transaction log backup record with no corresponding full backup record.
8. If you want to save the results , click Copy Results To Clipboard, or right-click to save the results in a data table, or as an XML or CSV file.

...

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...

...