Restoring MS SQL Server .bak from S3 to AWS RDS

This information will educate you learn how to seamlessly restore an MS SQL Server database (.bak file) from an AWS S3 bucket to an AWS RDS occasion.

Let’s Get Began

Step 1 – Add .bak file to S3

Start by importing your .bak file to an S3 bucket utilizing the AWS CLI. Open your terminal and run the next command:

aws s3 cp mydb.bak s3://your-bucket-name/

Step 2 – Create an IAM Function

Navigate to AWS IAM and create a brand new function with the next permissions:

• AWSBackupServiceRolePolicyForS3Backup
• AWSBackupServiceRolePolicyForS3Restore

Screenshots:

Step 3 – Configure Choice Group

Go to RDS > Choice teams and create a brand new group:

• Title: SqlServerBackupRestore
• Description: (Your Description)
• Engine: Choose your DB engine
• Main Engine Model: Choose your DB occasion model

Screenshots:

Step 4 – Edit Choice Group

After creating the group, click on on its title to edit.

Add a brand new choice:

• Choose choice: SQLSERVER_BACKUP_RESTORE
• Select the IAM function created earlier
• Choose ‘Instantly’ to schedule an instantaneous change.

Step 5 – Apply Choice Group to RDS

Return to RDS > Databases, choose your occasion, and click on Modify.

Select the Choice Group you created, choose ‘Apply instantly’, and click on Modify DB occasion.

Step 6 – Run SQL Command

Open SQL Server Administration Studio and execute the next command to provoke the restore course of:

exec msdb.dbo.rds_restore_database 
@restore_db_name='mydb', 
@s3_arn_to_restore_from='arn:aws:s3:::your-bucket-name/mydb.bak';

Step 7 – Test Restore Standing

To observe the standing of the restore operation, run the next SQL command:

exec msdb.dbo.rds_task_status;

Wrapping Up

Congratulations! You’ve gotten efficiently restored an MS SQL Server database from an S3 bucket to your AWS RDS occasion. This step-by-step information ensures a scientific strategy to managing your information migration effectively. Should you encounter any points, confer with AWS documentation or search help from the AWS neighborhood for immediate options. Pleased coding!

You Could Additionally Be In

The information from AWS relating to Importing and exporting SQL Server databases utilizing native backup and restore.

In addition to: