SQL Backup Pro From Redgate Software With Amazon S3 Automatic Integration

In a move that reflects the growing adoption of cloud storage, the latest version of SQL Backup Pro from Redgate Software Ltd. now includes automatic integration with Amazon S3, making it easy for users to store their SQL Server backups in the cloud.

Click to enlarge

SQL Backup Pro simplifies the backup process, covering different and multiple versions of SQL Server, and allowing users to compress, verify and securely encrypt backups at the same time. This is all carried out from a centralized GUI, and the tool includes the option to automate backups, backup verification, restores and log shipping.

Amazon S3 is regarded as the standard in cloud storage, enabling users to upload and download files, choose the location of backups, access them from anywhere and pay for what they use. Given Amazon’s strengths, Redgate is retiring its own hosted storage service for SQL Backup Pro, originally launched in 2013, and is actively supporting customers so that they can migrate to Amazon S3.

“Whatever the size and complexity of your SQL estate, SQL Backup Pro just works, making the whole process simple, straightforward and secure,” says Mark Champion, marketing manager, product, Redgate. “By making it simple to integrate with Amazon S3, users will be able to benefit from one of the industry standards when it comes to cloud-based backups. While our own Hosted Storage service was a perfect fit for SQL Backup Pro when it was launched, Amazon is now superior, so we’ll focus on delivering the best backup tools, and let Amazon handle the cloud.“

The development team at the firm continues to streamline the integration with Amazon S3 and has also introduced permission management through Active Directory Groups, and the facility to allow jobs to be enabled or disabled through the GUI.

Compared to backing up using native SQL Server, SQL Backup Pro v9 saves storage space, speeds up network files transfers, and compresses backups by up to 95%. It also encrypts data in and across multiple versions of SQL Server, a factor which is coming increasingly under the spotlight with the upcoming requirements of the General Data Protection Regulation (GDPR).

While encryption was introduced in SQL Server 2014, many companies and organizations still have mixed SQL Server estates. This may cause issues when GDPR is introduced in May 2018, with Article 32, the security of processing, requiring the encryption of personal data, alongside the ability to restore it in the event of a physical or technical incident.

SQL Backup Pro v9 is available as a standalone tool and as part of the company’s SQL Toolbelt, which contains the industry-standard products for SQL Server development, deployment, backup, and monitoring.