CODEWITHSUNDEEP
sql-serveramazon-s3amazon-rdsdatabase-migration
who-aditya-nawandar
who-aditya-nawandar

Reputation: 1242

How to restore .bak file from an S3 bucket to RDS instance

I get this while trying to restore the .bak file to the new create rds instance.

Aborted the task because of a task failure or a concurrent RESTORE_DB request. Task has been aborted User: arn:aws:sts:::assumed-role/AWSServiceRoleForRDS/RDS-SqlServerBackupRestore is not authorized to perform: s3:GetBucketLocation on resource: "arn:aws:s3:::my-database-backup-bucket" because no identity-based policy allows the s3:GetBucketLocation action

AWSServiceRoleForRDS is the default AWS role. It doesn't take the role I created specifically for this task.

The current policy looks like this although I have tried multiple combinations before.

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "Statement1",
            "Effect": "Allow",
            "Action": [
                "s3:*"
            ],
            "Resource": [
                "arn:aws:s3:::my-database-backup-bucket"
            ]
        }
    ]
}

I don't know what I am missing. Please ask me for more info if you think it might help.

Upvotes: -1

Views: 49

Answers (0)

Related Questions