Red Gate’s SQL Backup Pro 6 Recovers from Interrupted Backups

Eliminates the time-consuming forensics required to recover interrupted backup operations following an outage

Note: ESJ’s editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements.

Red Gate Software has released SQL Backup Pro 6, featuring network resilience (to recover from interrupted backup operations), self-healing log shipping, and a new advanced compression algorithm. Says Colin Millerchip, SQL Backup Pro 6 product manager, “The new features in version 6 are Red Gate’s answer to backup issues that keep DBAs awake at night – the issues not addressed easily by native SQL Server or other backup software.”

As implemented in SQL Backup Pro 6, network resilience eliminates the time-consuming forensics required to recover interrupted backup operations following an outage. DBAs can use default settings or settings of their own to designate the length of time SQL Backup Pro 6 waits before retrying a transfer from where it was interrupted and also to determine the number of attempts SQL Backup Pro makes at retrying the backup operation.

If a network outage occurs while transaction log backup files are being copied, SQL Backup Pro 6 keeps a record of the affected files. When the network outage is resolved, the “self-healing” process begins: SQL Backup Pro 6 automatically re-attempts the transfer from where it was interrupted and reprocesses the affected transaction log files.

Other New Features

When storage space is at a premium, SQL Backup Pro 6 offers a new compression level for maximum backup compression. The software’s compression analyzer enables users to assess which of SQL Backup Pro 6’s four compression levels would be optimal, depending on whether the priority is speed or size of backup.

Other new features in SQL Backup Pro 6 include:

  • The ability to skip initialization of the database when performing log shipping if the target database is already set up with a full backup of the source database
  • A “kill existing connections” option to prevent a restore from failing if users are connected to a database while a restore operation is in progress
  • GUI enhancements, including faster loading of data, easier file browsing, and support for different purge options

More information, demos, and a fully functional, 14-day trial of SQL Backup Pro 6 are available at www.red-gate.com/backup.