Skip to main content

Backup/Recovery History

Home > Select Project > Stat/Report > Backup/Recovery History

It provides the records for database backup and recovery operations on the SQL Server. This helps you review the data protection and recovery strategy by checking its success or failure and detailed information.

  • You can check the backup success status and backup size for each database, and review the adequacy of the backup interval.

  • You can check that the recovery was successful and analyze the cause of error if the recovery failed.

  • Review the storage locations of backup files to ensure proper management and accessibility of backup files.

  • Analyze the continuity and recoverability of backup files, and review their security by checking whether the backups are password protected.

Note

If there is no item in the list, select Refresh icon.

Checking the backup history​

At the top of the screen, select the backup tab. It provides backup information for each database by querying the top 50 backup jobs based on the collected data. You can check the name and type of the backup job, software, size, and time point.

Backup history

For more information about the provided columns, see the following:

  • database_name: Database name for the backup job.

  • backup_name: Name of the backup set.

  • backup_type: Backup type.

  • device_type: Type of the backup device.

  • software_name: Software name for the backup.

  • recovery_model: Recovery model of the database.

  • compatibility_level: Compatibility level of the database.

  • backup_start_date: Date and time when the backup started.

  • backup_finish_date: Backup completion date and time.

  • latest_backup_location: Physical path of the backup device.

  • backup_size_mb: Size (Byte) of the backup set.

  • compressed_backup_size_mb: Total size of backups stored on disk.

  • database_backup_lsn: Log sequence number of the most recent full database backup.

  • checkpoint_lsn: Log sequence number of the log record to be run again.

  • begins_log_chain: First chain (1) in the continuous log backup chain. The log chain starts with the first log backup performed after creating the database or when transitioning from a simple model to a full or bulk-logged recovery model.

  • is_password_protected

    • protected: Password protected backup set

    • Not protected: It is not protected.

Checking the recovery history​

At the top of the screen, select the recovery tab. Top 50 recovery jobs are viewed. You can check the restored database, its recovery type, and user information. You can identify the target database, time point, and file path for the recovery.

Recovery history

For more information about the provided columns, see the following:

  • restore_database_name: Target database name of the recovery.

  • backup_name: Name of the backup set used for recovery.

  • restore_date: Date and time when the recovery operation started.

  • restore_type: Type of the recovery operation.

  • user_name: Name of the user who performed the recovery operation.

  • backup_server_name: Name of the SQL server that ran the backup operation.

  • backup_database_name: Name of the database from which the backup set used for recovery was created.

  • destination_phys_name: Physical path of the restored file.

Filtering the searched results​

Adding the filter conditions​

  1. In the Filter option, select .

    Adding condition

  2. In Filter key, select a desired filtering criteria.

    • If the value of the selected item is text, you can select any of Includes (blue) and Excludes (red).

    • If the value of the selected item is number, you can select any condition of == (equal to), >= (greater than or equal to), and <= (less than or equal to).

  3. In Condition, select a condition.

  4. Enter a string or number to match the condition.

  5. Select Apply.

Note

  • To add filtering conditions, select Add and then repeat Step 1 to 5. Added conditions are applied based on AND (&&).

  • To delete some items while adding conditions, select Delete icon on the right of the filter conditions. To delete all conditions, select Delete icon Delete All.

  • To quickly delete the conditions applied to the Filter option, select .

Modifying the filter conditions​

Edit filter

Click any applied to the Filter option. If the Edit filter window appears, modify any desired items and then select Apply.

Downloading the viewed result​

You can download the backup or recovery history in CSV file format. Select a desired tab and then select csv icon at the top of the screen.

The name format of the downloaded CSV file is as follows:

  • backup: backup_history_YYYY-MM-DD_HH-MM-SS.csv

  • recovery: recovery_history_YYYY-MM-DD_HH-MM-SS.csv