Cloud infrastructure makes life easy for IT people. The common task for any IT project is maintaining back-end data.

AWS provides database as service which is commonly known as Relation Database Service (RDS). It has the support of all popular databases like SQL server, MySQL, and PostgresSQL.

AWS RDS provides a built-in service for backup, which is configurable. It takes the snapshot of your entire DB instance and keeps it in AWS infra as a backup. Although this service work fabulously, there are times when you need to have database file natively stored on your machine.

This article will elaborate on the process of creating a .bak file from the AWS RDS SQL server instance.

Login to your AWS console and navigate to RDS, from the side menu locate the link for the options group as shown below

You will be redirected to the page for creating a new option group

Provide appropriate name and description for option group, its essential to keep and Engine and its number the same as of RDS database.

Once you have created an option-group, you need to add an option you will be redirected to the screen for adding an option

Select Sql server backup restore from the option dropdown

Create a new I am role, AWS will automatically grant access to this role for SQL server backup and restore

you can apply this option group to reflect immediately or at scheduled maintenance time.

For storing the backup file you need to create a bucket in S3 storage. Navigate to S3 storage and add the bucket as shown below

Keep the default settings as it is. Once you are ready with the bucket, All you need to do is to execute the below command on your MMC

exec msdb.dbo.rds_backup_database



Replace database_name with the actual database name, and bucket_name with the actual name of the bucket.

Similarly, replace file_name.extension with the name of the file and its extension

It will create a backup file in s3 bucket.