How To Automate SQL Server Backups on EC2 to AWS s3

Thank You for Watching!

Checkout my SQL Server Administration 2022 Course on Udemy: https://cutt.ly/sqlserver2022

In this video, you will learn the following:

1. How to create a AWS s3 bucket.
2. How to create IAM roles in AWS.
3. A little of AWS Cli
4. How to schedule a process using windows task
5. How to automate your backups.

s3 command: aws s3 cp D:\SQLBackup\TestSpace\Full\ s3://rdxtestbackup/SQLBackup/ –recursive

Instead of using RMDIR in the batch script, cleanup task can be added to the maintenance plan to remove backups older than x days old.

The same can be with on-premise server, but instead of a role you would configure the AWS Cli with a user that has access to the s3 bucket.

It's good a practice to store your backups on a separate server or storage location.

**NOTE**: There are multiples ways to achieve this.

Тэги:

#how_backup_sql_server_to_aws_s3 #aws_database_backup_and_restore #how_back_sql_server_on_aws #how_to_automate_sql_server_backs_on #how_to_copy_file_from_windows_ec2_ro_s3_bucket #amazon_web_services #amazon_s3 #aws_tutorial #aws #s3 #aws_s3

Скачать видео