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!

Advertisement

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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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

%d bloggers like this: