We have an issue on one of the SQL instances with the backups. We are using SQLBackup 18.104.22.168, and have log shipping setup for about 45 databases that runs hourly log backups, and backs them up to a local drive (we then have another process that copies the files to the client's FTP). Sometimes the log backup gets stuck for one of those 45 databases. It still runs successfully for all other databases, however doesnt run for that particular database (for which its stuck). To resolve that we have to restar the SQLBackup Agent service. Until we do that, it will show as backing up, when we run 'sqbstatus' command, however the 'processed' and 'compressed' numbers are not changing. So essentially its stuck. This is causing quite a big of issue for our clients, and i am wondering if anyone has encountered this issue, and what the fix is.
Also, just a note, we are running 50 other SQL instances, some with more than 80 databases, with the same 22.214.171.124 version of SQLBackup, and log backups are running every 15 mins, with no such issues.
This issue is only happening on the instance where we have log shipping setup.
Any help would be greatly appreciated, as we are out of ideas.