CODEWITHSUNDEEP
sql-serverbashamazon-s3powershell-3.0
Bernat Moragas
Bernat Moragas

Reputation: 31

Script to backup SQL Server and save the files into Amazon s3

I'm trying to set up an automatic backup from SQL Server to S3 script or batch, but I didn't find the way who to do it without a third party software.. :(

Any of you have an experience before with it?

Thanks in advance,

Bernat

Upvotes: 1

Views: 741

Answers (1)

Bernat Moragas
Bernat Moragas

Reputation: 31

Well, I found a workaround, maybe is not the best way to do it, but i don't need to keep the files in EC2 server volume and i can move it to s3. I create a normal backup job, keeping the files for two days and synchronizing the local folder to S3 with AWS command cli job every morning. With this we are moving every day the files to S3 folder:

aws s3 sync folder s3://mybucket1

I hope that it helps.

Cheers,

Bernat

Upvotes: 1

Related Questions