SQLBackup 4 errors after a few days of running
After installation, I've configured a number of SQLServer scheduled tasks to back up my databases using calls to sqlbackup extended proc.
These all work fine for a few days, however after a varying period of time, all backups will start failing with the following message.
Execute interrupted by exception: Access violation at address 14B382C3 in module 'xp_sqlbackup.dll'. Write of address 00000000 [SQLSTATE 01000] (Message 0) BACKUP OF DATABASE msdb Failed. [SQLSTATE 42000] (Error 50000). The step failed.
When this starts to happen, attempting to use the user interface and connect to the offending server also results in no connection being made and the exception message appearing in the lower left hand pane of the the interface.
Attempted restarts of the SQLBackup service do not remedy the problem.
And the only resolution I've found so far is to remove the server components and re-install them. This results in the backups starting to work again, but only for a few days, after which the above symptoms return.
I have three questions:
1) Why is this occurring?
2) Is there a fix/reconfiguration available to cure it?
3) If it happens is there a better resolution?