BACK UP SQL TO AMAZON S3
SQL Backup Master allows you to back up your SQL Server databases to the reliable, secure, and highly scalable Amazon S3 service.
Amazon S3 is a premier destination for professional-grade cloud storage, and SQL Backup Master integrates seamlessly with its powerful feature set. Connecting to your AWS account is managed through secure IAM (Identity and Access Management) credentials. By providing an Access Key and a Secret Key for a dedicated IAM user, you ensure that our application has only the permissions it needs to manage backups, following security best practices.
As shown in the screenshot, configuration is simple. After providing your credentials, you can select your desired Amazon S3 bucket for storing your SQL backups. A bucket is a unique container for your data on S3, and you can specify a folder path within the bucket for even better organization. This level of control is ideal for managing backups from multiple servers or applications.
One of the greatest benefits of using Amazon S3 is the ability to optimize storage costs and performance using its advanced features. SQL Backup Master provides direct support for:
- S3 Storage Classes: You can assign a storage class (such as Standard, Standard-IA for Infrequent Access, or One Zone-IA) to your database backups. This allows you to dramatically reduce costs by moving less frequently accessed backups to cheaper storage tiers.
- Server-Side Encryption: Enhance the security of your data at rest. When you enable this option, Amazon S3 encrypts your backup files automatically as they are written to disk in the data center, using powerful AES-256 encryption.
- S3 Transfer Acceleration: For geographically distant uploads, enabling Transfer Acceleration can significantly speed up the transfer of your backup files by routing them through Amazon's optimized global edge network.
Advanced features include support for server-side encryption, transfer acceleration, various storage classes, and much more.
Related article: How to back up SQL Server databases to Amazon S3