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, click .

  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

Adding and Deleting Filter Conditions

  • To add a filtering condition, click the Add button and repeat steps 1~5. Added conditions are applied using the AND (&&) operator.

  • To delete specific conditions while adding, click the Delete icon button on the right side of the filter condition. To delete all conditions, click the Delete icon Delete All button.

  • To quickly remove all applied conditions from the Filter option, click the button.

Modifying the filter conditions​

  1. Click the applied item in the Filter option at the top of the screen.

  2. In the Edit filter window, edit the desired item and click the Apply button.

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

Last updated on