Viewing blog posts in a specific category.
I was hosting http://h1bsalary.online site from AWS on m3.xlarge Instance. Even though its reserved instance , the cost of hosting has crossed the threshold limit of hobby project. So I have decided to host the site from Home . In this blog post, I am sharing my experiences with hosting the website from Home instead of public cloud provider.
We typically get data feeds from our clients ( usually about ~ 5 - 20 GB) worth of data. We download these data files to our lab environment and use shell scripts to load the data into AURORA RDS . We wanted to avoid unnecessary data transfers and decided to setup data pipe line to automate the process and use S3 Buckets for file uploads from the clients.
These are the steps I followed to enable Native Backup and Restores on AWS SQL Server RDS 1. Created NativeBackupRestore Role and Enabled S3 Bucket Access 2. Created Custom Options Group and enabled to use the NativeBackupRestore Role 3. Modified existing instance to use custom options Group. 4. Successfully Backed up the Database from RDS Instance to S3 Bucket 5. Successfully Restored Native Backups on S3 on SQL Server RDS.