Monitoring Backup and Restore with SMC ​

You can monitor backup and restore operations by running system view queries or by looking at the reports in the SMC.

SMC Monitoring ​

Go to Monitor > Backup/Restore Processes in the SMC.

You can filter backup and restore events and look at the details for individual operations. For example:

The Databases view in the SMC also shows which databases are in HOT_STANDBY mode, either because they were restored or because they are active replicas. For example:

System Views ​

Write queries against the following system views:

• sys.backup (monitor backups in progress)
• sys.log_backup (view backup history)
• sys.restore (monitor restores in progress)
• sys.log_restore (view restore history)
• sys.backup_chain (list backup chains)
• sys.backup_snapshot (list backup snapshots)

See the view descriptions for examples.

If you are taking backups with ybbackup and using database replication, the sys.backup_chain and sys.backup_snapshot views contain information about chains and snapshots that apply to both types of operations.