Before addressing the issue of backup size reduction with compression enabled, let me provide some context. When SQL Server is hosted on AWS EC2 instances, you’ll need to manage the backup strategy appropriate to your business. In order to persist and archive your SQL Server backups securely and permanently, AWS S3 is a prime target: it’s the service with the…
In the last post we had a look on how you can use AWS Storage Gateway as File gateway to store your PostgreSQL backups safely offsite on AWS S3. Another method of doing that would be to use “Cached Volume gateway” instead of the File gateway we used in the last post. The volume gateways does not provide access via…
In the last post we had a quick look at AWS Kinesis data streams and how you can push data to AWS S3 using AWS Firehose. Another great AWS service is AWS Storage Gateway and in this post we’ll use that to push our PostgreSQL backups to AWS. The primary usage of AWS Storage Gateway is to extend you local…
