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

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 easily, choose the location of backups, access them from anywhere and only 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.

The development team at Redgate 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%. Crucially, 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 Redgate SQL Toolbelt, which contains the industry-standard products for SQL Server development, deployment, backup, and monitoring.