Mismatched Incremental Backup Time with BDRSuite Database

Mismatched Incremental Backup Time with BDRSuite Database

KB ID: 110004
Cause:
If you were using another backup software concurrently with BDRSuite, inconsistency in backup sets might occur, especially when backing up SQL Server database(s) using multiple applications. This inconsistency arises from SQL Server changing the reference of the database dump when two schedules attempt to back up the same SQL Server database. Consequently, the backed-up data may become inconsistent when processed across two schedules.
Solution:
1. Use Only One Backup Software for SQL Server Database Backups:
Configure SQL Server database backups using only one backup software to avoid inconsistencies.
2. Choose Full Backups for Added Redundancy:
  1. If you opt for added redundancy with more than one backup software, configure only 'Full Backups' of SQL Server databases.
  2. This ensures that BDRSuite and other backup applications back up only full backups of SQL Server databases for each schedule.
3. Consider Time and Bandwidth Implications:
  1. Keep in mind that this process may require more time and bandwidth.
  2. Adjust the backup frequency based on your available bandwidth.
4. Prevent Schedule Collisions:
  1. Ensure that backup schedules of any applications do not collide with each other.
  2.  Schedule backups to occur upon completion of the other backup job to avoid conflicts.
Following these guidelines should help in mitigating inconsistencies in the incremental backup time associated with databases. If the issue persists, consider reaching out to BDRSuite support for further assistance.

    • Related Articles

    • Configuring MySQL Database Backup

      Step 1: Adding Basic Job Details Enter the following details; Backup Job Name: Provide any proper name for your backup job. Backup Repository: Select the backup repository type. You can choose either Block Storage or Object Storage. Repository Name: ...

    • Handling "The Database Missed a Previous Full Backup Before the Incremental Backup" Error in BDRSuite Client

      KB ID: 89 Issue: Users may encounter the error message "The database missed a previous full backup before the incremental backup" in BDRSuite Client. This can occur due to various reasons, and the article provides solutions based on the specific ...

    • Configuring MS SQL Database Backup

      Step 1: Adding Basic Job Details Enter the following details; Backup Job Name: Provide any proper name for your backup job. Backup Repository: Select the backup repository type. You can choose either Block Storage or Object Storage. Repository Name: ...

    • Addressing Issues with Incorrect Next Backup Schedule Time in BDRSuite

      KB ID: 115 Causes: The "Next Backup Schedule Time" may appear empty or be updated incorrectly in the "List Job" window due to the following reasons: 1. Manual changes to the system time. 2. Rare cases of database update failure. Solution: To rectify ...

    • Backup aborted

      KB ID: 101005 Product: BDRSuite Backup Server Cause This will occur due to the following reasons: Backup configuration stored in the server and client is incompatible. When the Backup storage location is inaccessible to the backup server. If you ...