SQL Backup Pro

Compressed and encrypted backup and recovery for SQL Server databases.

SQL Backup Pro creates compressed, encrypted backups of Microsoft SQL Server databases. It enables you to schedule backup jobs, taking faster, smaller and more secure SQL Server database backups.

Key Features

• Multiple compression levels available. Save storage space, speed up network file transfer, and get up to 95% backup compression.
• Secure your backups with 256-bit AES encryption.
• Integrates with SQL Server Agent to schedule database backup and restore jobs.
• Timeline Monitoring in the GUI for visualisation of activities at a glance.
• Command-line interface, so you can run your backup and restore operations in script and batch files.
• Network resilience for fault-tolerant backup transfer, including automatic resuming of interrupted transfers.
• Scriptable support for network resilience for restores.
• Cluster-aware installation mechanism with cluster support.
• Email notification of backup and restore activities.
• Enterprise and server level reports.
• Automatically kill existing connections before restoring to prevent failure of the operation.
• Automatically check for orphaned users, and receive a list of those affected.
• Skip initialisation of the database for log shipping.
• Access and manage all SQL Server backups remotely, from a central, client-based GUI.
• 'Self-healing' log shipping queues the transfer of transaction log backups, if it is interrupted, and restores in the correct order.
• Upload a copy of your backups to the cloud, protecting your data from onsite disaster and you will get your first 5GB of storage free.

SQL Backup Pro - Features

New features in version 4 Features comparison

SQL Backup Standard Edition

SQL Backup Standard Edition is the essential replacement for SQL Servers built-in backup and restore functionality. With its simple-to-use GUI, and a powerful command-line interface, your backups are smaller, faster and more secure. SQL Backup Standard Edition is ideal when you need to back up smaller SQL Server implementations from one to five servers.

Features include:

• Up to 95% smaller backups, using our advanced compression algorithms multiple compression levels provide flexibility
• Up to twice as fast as native backups
• Multiple encryption levels up to 128-bit using the AES (Rijndael) algorithm, the standard specified by the US government for encrypting Top Secret data
• Access and manage all server backups remotely, from a central client-based GUI
• Compatible with both SQL Server 2005 and SQL Server 2000
• Stay in control of the Log Shipping process with SQL Backup's advanced Log Shipping wizard
• Simple-to-use GUI, or powerful command-line interface

SQL Backup Pro

SQL Backup Pro is an enterprise-level tool that scales to meet the needs of any SQL Server implementation, from 5 servers to 500. Access and manage all server backups remotely, from a central, client-based GUI. Secure your data, and meet compliance requirements, with military grade 256-bit AES encryption. And if the worst happens, use Red Gate's SQL Log Rescue tool to restore transactions made since your last backup.

Features include:

• Up to 95% smaller backups, using our advanced compression algorithms multiple compression levels provide flexibility
• Up to three times as fast as native backups
• Multiple encryption levels up to 256-bit using the AES (Rijndael) algorithm, the standard specified by the US government for encrypting Top Secret data
• Access and manage all server backups remotely from a central, client-based GUI
• Compatible with both SQL Server 2005 and SQL Server 2000
• Stay in control of the Log Shipping process with SQL Backup's advanced Log Shipping wizard
• Simple-to-use GUI, or powerful command-line interface
• Object-level recovery and log analysis with the SQL Log Rescue tool

New features in version 4

• Pro and standard editions split
• Remote back up and restore (Pro only)
• 256-bit encryption (Pro only; standard version still has 128-bit encryption)
• Support to SQL Server 2005
• Improved compression algorithm
• Back up File/Filegroup
• Schedule Backup Wizard (can select multiple databases to script in one go)
• New UI
• Log Shipping Wizard

Minor new features in version 4 include:

• Backup and restore history data will be saved in the msdb table instead (as per native SQL Server) as oppose to in a file on disk. This makes it possible to get backup/restore history data from remote servers. The new Activity history grid will display the last few backups and restores, with SQB backups/restores highlighted and includes statistics of the compression achieved and the speed.
• You can determine the age of old backups, and choose when they should be deleted (before or after running the next backup) in hours as well as days.
• You can set to delete SQL Backup log files (stored on disk), older than a certain age.
• Extended stored procedure can now return last SQB error code and last SQL error code.
• Unicode outputs ok in extended stored procedure. This means if you run remotely to a Chinese SQL Server, for example, all outputs in Chinese will be displayed correctly on an English OS if the necessary fonts are installed.
• Can set to send an email only when there's an error.
• Can script to backup multiple databases using, for example, 'BACKUP DATABASES [*]' or 'BACKUP DATABASES [a, b, c]' (similarly for log backups, BACKUP LOGS [*]).
• New keyword EXCLUDE (so you can say, for example, backup all databases except these ones).
• New keyword THREADS to automatically backup to a given number of files, so that the user does not need to name every file in a split backup e.g. BACKUP DATABASE pubs TO DISK = [] WITH THREADS = 2.
• New Job Failures tab, to see scheduled jobs which have caused an error.
• Facility to highlight databases which have not been backed up within a specified amount of time Backup alerts.
• Removed Tools dialog (MD5# and verify files).
• Scripts are displayed with syntax highlighters.
• A reset button to go back to the original file name format.
• improved support for usage of tags in backup file names
• improved extended stored procedure feedback
• added management dialog for extended stored procedure rights
• added display of server properties
• added support for Unicode text

Features comparison

Feature	Standard Edition	Pro Edition
Up to 95% smaller backups	Yes	Yes
Up to twice as fast as native backup	Yes	Yes
128-bit AES Encryption	Yes (128-bit)	Yes (256-bit)
Multiple compression levels	Yes	Yes
SQL Server 2005 compatible backups	Yes	Yes
Simple log shipping process with the Log Shipping Wizard	Yes	Yes
Simple to use GUI, or powerful command-line interface	Yes	Yes
Access and manage all server backups remotely, from a central, client-based GUI		Yes
Multiple encryption levels, up to 256-bit AES Encryption		Yes
Object-level recovery and log analysis with the SQL Log Rescue tool		Yes




SQL Backup Pro - System Requirements

• Windows NT, Windows 2000, Windows 98, Windows ME, Windows XP or Windows 2003 Server
• SQL Server client-side tools (SQL Compare)
• Microsoft .NET Framework 1.0.3705+ (except SQL Backup)
• MDAC 2.6+
• 128 MB RAM, 10 MB hard disk space
• Runs on a user's PC (can also run on a server)
• Visual Studio .NET, or similar programming environment that uses the .NET Framework (SQL Toolkit only

SQL Backup only supports SQL Server 2000.