Posted by: Colin Smith
We recently had our bits upgraded to the latest and since that we have had some issues with the product. We have run into issues where the SQL Server that has copies of your databases in a restoring state, have stopped grabbing the log backups and applying them. This is an issue as it has made me run out of space in the areas that I am storing my log backups. This happens because I have a Powershell script that finds out what logs have been applied and then goes and deletes the log backup files that have already been applied. So the issue is that if logs are no longer being applied, the script can not remove the files. This prompted me to add some alerting into that script and now I am alerted when more than x number of files are on the disk. That way I can take a look at what is going on and figure it out before it becomes an issue. We think we have figured out the reason that we are having this issue though. We have to install some software on the SQL Host and I think that when we upgraded our bits, this software was not updated. So I removed the software and installed the new version and this caused some huge issues. Now I am dead in the water and waiting for support to call me back to help me out. So I think this is a big bug. We need to have a way to upgrade all components of the product without causing these issues.