Finalizing SQL Backup Assessment (Part 3)

After testing HyperBac yesterday in our SQL Backup tools series throughout this week, we realized that SQL Backup Pro is the way to go.  The HyperBac compressed backups were not smaller than either SQL Server native compression or SQL Backup Pro.  However, all three integrated well with our Ola Hallengren maintenance scripts.  We also decided to do one native backup a week for disaster recovery purposes in case we cannot get the tool to work following a disaster.  With a proprietary tool, my manager felt better in a DR scenario having at least one native backup, so ‘we gotta do what we gotta do’ to keep everyone happy.

I have recommended to Red Gate that they add more automation into the scheduling of Virtual Restore jobs to grab all of the databases in the job instead of individual jobs for each database.  That I think is the only area I found to be lacking in the tool.

Enjoy your weekend.

Advertisements

About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, 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 7, 2012, in Maintenance and tagged , . Bookmark the permalink. 2 Comments.

  1. So are you recommending to your company to purchase Red Gate Backup? What is your reasoning, if so?

    Personally, we were using Red Gate Backup until recently, but mostly for compression. After review, we have reverted to using all natives since we’re now almost completely on SQL 2008 R2 and can make use of native compression, which compresses about as much as Red Gate’s default settings. There wasn’t much of a value add for us from Red Gate’s tool.

    • Ours was about the same until we cranked up the compression and then we saw a considerable difference. Thanks Mike, how ya been?

      On Fri, Dec 7, 2012 at 12:19 PM, SQL Swampland

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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: