Archiving sql data to Amazon S3
Posted on 2014-10-14
On Amazon cloud platform, we have sql server databases on ec2 instances with data storing on EBS volumes.
one of our database has highest writes and the database size is getting bigger, as we know the data storing on EBS volumes are bit expensive,
Our requirement is to maintain one to three months data on EBS storage and the data which is more than three months old should be archived to S3, which gives us a direct chance to look on S3 for data which is 3 months old.
Would that be possible to store the archived database files on S3?
If so how can we retrieve the archived data from S3 when needed?
if we go for partitioning tables on sql server, the data will be on EBS volume itself, but here we want to archive it to s3 and when ever user wants to check for the history they should able to retrive directly from s3.
Thanks in advance.