How To Automate SQL Server Backups on EC2 to AWS s3

[@TrevoirWilliams]

Showing support for a fellow Jamaican. Nicely done!

[@redincs]

Appreciate it bro!

[@kenigiri]

Well done!

[@saineydrammeh9035]

Nice! Thanks.

[@redincs]

Thank you too!

[@ericliu1114]

Thanks for the video.

[@redincs]

You are welcome!

[@usmanqureshi1982]

That was Great man.. thanks

[@brook_dba2118]

Thank you for a great video. Question have you tested this on SQL Server 2016 or any prior versions of SQL Server other than 2022? I know it’s a new functionality on SQL server 2022 that you can take a direct backup to an s3 bucket. Many thanks!

[@redincs]

Hey brook, no new functionality here. This should work for versions like 2012. My latest video used the new functionality.

[@KrishMMS]

Great video.. thank you!

[@redincs]

My pleasure!

[@karinatasha62]

Hi! this video is exactly what i've been looking for. huge thank you for this!!! i have a question, will this also remove the files in s3 that are no longer in server? the reason is i have maintenace task in SQL to clean up the back up files older than 7 days in server but i want to make sure the "removed" files remain in s3 when synced

[@redincs]

Thank you. No, you would need another script to delete the s3 files.

[@karinatasha62]

@@redincs awesome! thanks

[@arumugams4673]

I have also seen the option while doing backup to enter the destination as disk or url . can we directly send the backup files to s3 using the url option?

[@redincs]

Yes, if you’re SQL 2022. I have a video on how to back to AWS S3 bucket.

[@camilagomez9784]

Is there any chance we can run this task right after the job on SQL Server is done?

[@redincs]

Yes...create job step in the main job

[@alejandradubon9052]

Hello! very good video, new subscriber, I have a physical server in Windows server and I want to be uploading automatic backups to the S3 bucket, I want to upload a 300 GB partition, what is the best way to do it and make it economical? We are a small entrepreneurial company and we don't know where to start

[@redincs]

Hey thank you: blog.cloudthat.com/syncing-data-on-premise-aws-s3-using-data-sync/. I will do a video in the future

[@vijaydynamo4050]

Is the same techniques for ubuntu aswell??

[@redincs]

Yes.

[@mosestiamiyu6016]

thank you for your video you address all I needed. would love to connect with you pls. I ran the task scheduler job it was uploading almost everything on my EC2, what do you advise?

[@redincs]

Create a role that will give the server access to the s3 bucket. Rewatch the video maybe you missed that step.

[@redincs]

specify the path and backup file pattern eg. c:/backup/file_*

[@mosestiamiyu6016]

@@redincs I followed all over again, when I run the job on powershell it backs up all my files in the backup drives but when I set it up on Task Scheduler and run it uploads everything on the ec2 minus the database.

[@redincs]

Try this: aws s3 cp D:\SQLBackup\TestSpace\Full\ s3://rdxtestbackup/SQLBackup/ -recursive

[@mosestiamiyu6016]

resolved bro, thanks alot. loads of love from New York

[@kennethigiri765]

Well done!

[@redincs]

Thank You!