The Multifunctioning DBA

Oct 23 2012   7:30PM GMT

Virtualization Issues

Colin Smith Colin Smith Profile: 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.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: