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

    • 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 ...
    • Issue: Full Backup Time Mismatch Troubleshooting

      KB ID: 110003 Cause: The mismatch in full backup time is observed when utilizing another backup software concurrently with Vembu NetworkBackup. Performing SQL Server database backups through multiple applications leads to inconsistency in backup ...
    • Differential Backup Time Mismatch with Vembu NetworkBackup Database

      KB ID: 110005 Cause: If you are using another backup software alongside BDRSuite and backing up SQL Server database(s) using multiple applications, it can lead to inconsistency in backup sets. This issue arises when two schedules attempt to back up ...
    • 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 ...
    • Steps to Rebuild BDRSuite Backup Server running v5.3.0 and above (PostgreSQL Database)

      KB ID: 115900 Challenge A hardware failure or system crash on the BDRSuite Backup Server machine can result in the loss of both the BDRSuite application and its backend database (PostgreSQL server). Solution In case of backup server failure/crash, If ...