Tag Archives: amazon s3

How to set up Cloud-based Storage for SQL Server Backup

A central tenet of Disaster Recovery (DR) is that you should always maintain an offsite or off-premises copy of your critical database backups. The logic behind this is simple – if you don’t have access to your premises, for example in case of a natural disaster affecting your area, your offsite backups mean that you can restore them and still have access to your critical data. Let’s take a more in-depth look at cloud-based storage for your SQL Server backups. Continue reading How to set up Cloud-based Storage for SQL Server Backup

Set Amazon S3 access policy to minimum permission

Amazon S3 access policy to minimum permission
Most admins will prefer to create, due to security reasons, accounts for any system with minimum privilieges.
So, now you might wonder how to create a user for Amazon S3 service that has minimum permissions in order to backup databases with SQLBackupAndFTP in a certain bucket and folder? It’s quite easy…

Continue reading Set Amazon S3 access policy to minimum permission