Red Gate Backup Pro Update After A Weekend of Jobs (Part 6)

Last week I blogged about my experiences implementing the Red Gate Backup Pro and Virtual Restore.  Today I have a few more observations and items that I need to investigate.

  1. We setup a weekly copy-only backup using default SQL Server compression to give my supervisor ‘warm and fuzzies’  over switching to a proprietary backup format.  We noticed this weekend that the servers with the HyperBac/Virtual Restore tools installed failed on a regular backup.  When we manually stopped the HyperBac service and ran the backup, it completed successfully.  When we re-enabled the service the backup failed again.  We decided to forgo using HyperBac, I may try deactivating that part of the license and see if that alleviates the issue.
  2. Some of our restores fail when we script them and run fine when we run them manually.
  3. Some of the restores report DBCC CHECKDB issues and when we run DBCC CHECKDB on the actual database there are no issues.
  4. I would like to script the real Virtual Restore product, but as of yet have been unable to.

I will keep everyone posted as to my progress.  Enjoy!

Unknown's avatar

About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on December 17, 2012, in Maintenance, Scripting and tagged , . Bookmark the permalink. 1 Comment.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.