AWS Lambda Python Script to create Database Snapshots

The below script is used to create a database manual snapshots on all regions in an AWS account.¬† RDS support automatic snapshots which are very useful for point in time recovery but it does not protect you from accidental deletion of RDS instances. Here are the reasons why we need manual snapshots Accidental RDS InstanceContinue reading “AWS Lambda Python Script to create Database Snapshots”

How to Migrate SQL Server Database running on EC2 instance to Amazon RDS Instance

Recently i worked on migrating sql server databases running on amazon EC2 instances to Amazon RDS¬†instances. Starting from 27th Jul 2016 Amazon announced you can ship your databases from ec2 to rds using native backup and restore method. Let’s see how it works. Steps: Assume you have RDS Instance ready with default setting Create aContinue reading “How to Migrate SQL Server Database running on EC2 instance to Amazon RDS Instance”