Resolving Full Backup Time Mismatch Issues - Expert Tips

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 sets, especially when both applications attempt to back up the same SQL Server database. This inconsistency arises from SQL Server altering the reference of the database dump when two schedules attempt simultaneous backups.
Solution:
To address this issue, follow these steps:
1. Use Only One Backup Software:
Configure SQL Server database backups using only one backup software to avoid inconsistencies. If you require additional redundancy by using multiple backup software, configure only 'Full Backups' for SQL Server databases. This ensures that BDRSuite and other backup applications back up only full backups of SQL Server databases for each schedule.
2. Considerations for Bandwidth and Time:
Since the process of full backups demands more time and bandwidth, adjust the backup frequency based on your available bandwidth. Additionally, ensure that backup schedules of any applications do not overlap and are scheduled upon completion of other backup jobs.
3. Edit Backup Schedule:
To resolve the mismatch in full backup time, configure an additional full backup by editing the backup schedule. Verify the backup results after making the necessary changes.
By following these recommendations, you can ensure consistency in the backup sets and avoid the mismatch in full backup time within the Vembu NetworkBackup database.