How can we help you today? How can we help you today?

SQL Backup or Backup + Hyperbac or ?

We have purchased the DBA bundle, but I'm unclear on some of how I should best use the various tools.

We originally purchased SQL Backup for it's compressed backup features. It sounds to me like Hyperback transparently provides compression to the normal SQL backup operation.

That being the case, should I be using SQL Backup with compression, or a normal backup with Hyperbac handling the compression?

In particular, I'd like to make optimal use of Virtual Restore, which it sounds like works best if a normal backup + hyperbac is used, rather then SQL Backup with compression turned on.

Or am I totally not understanding this at all? When would I want to use SQL Backup 6 over the built in backup with Hyperbac?

Thanks!
coleman
0

Comments

5 comments

Sort by
  • petey
    See this page for a comparison of the 2 products.
    petey
    0
  • coleman
    Thanks, but outside of if I'm in a network scenario, that really doesn't help one decide when they would want to apply one solution over the other. And doesn't help answer my specific question of if one approach is better to use with Virtual Restore.
    coleman
    0
  • petey
    With regard to Virtual Restore, I believe the plan is for it to eventually support all backups created by SQL Backup. At the moment, I think it supports regular SQL Backup backups, but not encrypted SQL Backup backups.

    With regards to the choice of Hyperbac or SQL Backup, it depends on your needs. If you want a solution that does not require you to change your current maintenance scripts, or if the need to have a industry standard compressed file format is critical, then you should use Hyperbac.

    If the additional backup and restore features offered by SQL Backup is useful to you (see the link in my sig for details on some of them), then SQL Backup would be a more suitable fit.
    petey
    0
  • Colin Millerchip
    Hi,

    I can confirm we’re currently working on adding support for encrypted SQL Backup files to SQL Virtual Restore; so SQL Virtual Restore will work with any backup made with SQL Backup v6, as well as backups made with SQL HyperBac, and native SQL Server (compressed or uncompressed).

    In addition to the comparison page that petey referenced above, there’s a more details list of functional differences here.

    Hope this helps.


    Colin.
    Colin Millerchip
    0
  • DonFerguson
    Are there any long term plans to merge the two products into one?
    DonFerguson
    0

Add comment

Please sign in to leave a comment.