Determining the Backup Status of a Database

Find out when a database's most recent backup started, whether it failed, whether a backup is currently in progress, and more.

  1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
  2. In the left pane, select Databases.
    You can also display the Databases window by clicking a Databases link on another window in the monitor view.
  3. Locate your database in the Databases table.
    The table shows:
    • The date and time at which the most recent backup started
    • Whether a backup is currently in progress
    • Whether the most recent backup failed
    • Whether the transaction log is full
    • Whether there are suspended processes associated with this database
For more information on backups, see the sections on developing a recovery plan and on backing up and restoring user databases in the System Administration Guide, Volume 2.
Related tasks
Displaying Resources Used by a Database
Displaying Information About Segments Used by a Database
Related reference
Database Statistics and Details